SELECT a date = problem [MS SQL 2000]
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