compraring datetime content

mulmadmulmad Posts: 94
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


  • 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
Sign In or Register to comment.