datetime field weird problem

[nakai]

Hello,

I got a really weird problem when storing "datetime" fields into MSSQL 7. When I try to store a "datetime" for a date like "2001-10-19 22:41:00", the "datetime" ashly stored is "2001-10-19 21:41:17".

The computer is 1 hour late, indeed, but should not the database stores "2001-10-19 22:41:00" ANYWAY? And how come this 17 seconds delay?

Please, help!
Roberto.

 

[foxdev]

Are you specifying the time as a literal, or are you using GetDate() or CURRENT_TIMESTAMP? -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com