Posted by TGEAR on 12/08/05 21:32

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]