Posted by Dave Owen on 12/08/05 21:46

Jens suggested changing the value stored in your database because of
inherent imprecisions. Since you didn't do that try bracketing your query:
where auditime = <sometime before the event> and auditime = <sometime after
the event>

"TGEAR" <ted_gear@hotmail.com> wrote in message
news:1134070375.811541.231300@g43g2000cwa.googlegroups.com...
>I tried as below, but got an error msg "syntax error converting
> datetime from character string"
> where did i do wrong again?
>
> SELECT auditime
> FROM testtable
> WHERE (auditime = CONVERT(VARCHAR(50), '10/12/2004
> 7:28:02 AM', 120))
>

[Back to original message]