How can we help you today? How can we help you today?

compraring datetime content

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
mulmad
0

Comments

1 comment

Sort by
  • 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
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.