|
|
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.
Navigation:
[Reply to this message]
|