less than a particuler date problem

[cm80]

Hi my SQL statement is as follows:

SELECT * FROM event_log WHERE device_id = ABC AND event_time < &quot;9/13/01 1:58:05 PM&quot; ORDER BY event_time DESC

but the results include &quot;9/13/01 1:58:05 PM&quot; and I don't want them to. Is there some other way of doing this when dealing with dates or where am I going wrong

Thanks,

 

[fluteplr]

sql server stores time in milliseconds.

Try SELECT * FROM event_log WHERE device_id = ABC AND event_time < &quot;9/13/01 1:58:05:000 PM&quot; ORDER BY event_time DESC