G
Guest
In Europe, the transition from winter to summer time took place in 2007 on
march, 25th at 02:00.
Now if I insert a general time/date record into ACCESS 2002, SP3 with the
date/time "25/03/2007 02:xx", the time automatically advances by 1 hour and
in the database the record shows up as "25/03/2007 03:xx". This is not an
acceptable behaviour for my application, as I want to store UTC time series
in the database.
My question: how can I avoid this automatically adding of 1 hour to my time
record?
Thanks a lot for your help,
Carsten.
P.S.: Insert is done with Matlab's "fastinsert" using database toolbox.
march, 25th at 02:00.
Now if I insert a general time/date record into ACCESS 2002, SP3 with the
date/time "25/03/2007 02:xx", the time automatically advances by 1 hour and
in the database the record shows up as "25/03/2007 03:xx". This is not an
acceptable behaviour for my application, as I want to store UTC time series
in the database.
My question: how can I avoid this automatically adding of 1 hour to my time
record?
Thanks a lot for your help,
Carsten.
P.S.: Insert is done with Matlab's "fastinsert" using database toolbox.