Relative time in SQL
"Tom Ogilvy" wrote ...
Sorry, I wasn't aware that the Now function on a database server always
resolved to 7 AM. Thanks for the heads up although that seems kind of
buggy.
I don't think it does. Did you test this at 7am, perchance? <g
On my Jet database, I just executed
SELECT Now();
and I got the expected result of
24/08/2004 09:25:35
being the date/time from the server machine.
Jamie.
--
|