Posted by TGEAR on 12/08/05 20:06

each table has a auditime field which keeps the last data who modified.
I set this field as a datetime datatype and default value is getdate(),
so the value is recorded like this 10/12/2004 7:28:02 AM.
When I query to get that value, nothing showed up.
I made a query as below
select auditime from testtable where auditime = '10/12/2004 7:28:02 AM'
but nothing was fetched. what did i do wrong?

[Back to original message]