compraring datetime content

mulmad

I often experience that columns with datatype datetime does not compare correctly. The pattern seems to be that the hh:mm:ss is missed and I get:

date hh:mm:ss vs date 00:00:00

Chris Auckland

The datetime value in the results should be exactly what they are in the database.

Can you run a query in SSMS or Query Analyser to check the datetime columns in that table.

e.g. Select datetime_col from table