What kind of date comparison are you trying to do?
If you supply the date/time to SQL Server, a comparison will be made on the exact date
ie in a query
"SELECT * FROM myTable WHERE somedate = '1/22/01 12:51:18 PM'"
There MUST be a record in your database with the date/time as 1/22/01 12:51:18 PM
If you want to check for a particular data you will need to format as follows:
"SELECT * FROM myTable WHERE somedate >= '1/22/01 00:00:00' AND somedate <= '1/22/01 23:59:99'"
Note also that SQL Server does not like the date delimeters '/' it is best to format the date as a long date:
"SELECT * FROM myTable WHERE somedate >= '22 Jan 2001 00:00:00' AND somedate <= '22 Jan 2001 23:59:99'"
Hope this helps,
Chris Dukes