I am runing this VIEW :

SELECT users.id FROM users WHERE CONVERT(DATETIME, users.Inscription, 111) = CONVERT(DATETIME, '2006/02/14 12:00:00', 111)

the datestyle 111 = yy/mm/dd

I want to compare the dates without the times

the view returns nothing when they are > 10 rows in the database for 2006/02/14

how can i search on universal date yy/mm/dd ? or yyyy/mm/dd

in the datestyle there is nothing for yyyy/mm/dd thats crazy !

thank you for helping


date styles : http://www.sqljunkies.com/Article/66...C7FD826E5.scuk