Posted by Jens on 12/08/05 21:01

Due the the unprecision of the datetime column, which is only in a 3 ms
precision range (dependend on the way SQl Server evaluates the time
based on ticks) a row could not be fetch which
is apparently equals to your given expression, so converting it to the
same format (with chopping the ms) would evaluate the right rows:

CONVERT(VARCHAR(50),ColumnName,120) = CONVERT(VARCHAR(50),'10/12/2004
7:28:02 AM' ,120)

HTH, Jens Suessmeyer.

[Back to original message]