Adam wrote:

> The clocks on all OSes supported by Firebird use UTC *natively*, and
> only convert to a local representation upon request. In Windows for
> example, GetLocalTime is internally a wrapper around GetSystemTime and
> SystemTimeToTzSpecificLocalTime.

Please can you provide some more proof on this.

I've been back through three sites to check again now. If I change the
timezone in Windows - W2k and XP - then the HARDWARE clock time is changed.
In the past the railway systems always used to 'reset' at 2AM so you could not
run trains 24/7. When we introduced a rolling timetable, the switch of the
clock time at daylight saving caused problems so the fix was ORIGINALLY
introduced to keep the machines at GMT and simply display summer time when
appropriate. The world timezone stuff only came later.
( and going back to W98 days having to go around EVERY remote site and click
on the 'do you want to change the clock' popup each daylight saving change was
simply a joke :( )

LINUX does at least ask you if your hardware clock is GMT - although I would
have thought THAT should be described as UTC nowadays ;) THAT gets screwed if
you dual boot windows, and close out of windows - which resets the clock to
WINDOWS time so next time you boot into Linux the clock is wrong. But it's
been a while since I've had machines in that configuration to test current
state of affairs.

SO until it's proven otherwise I'll stick with ensuring that the hardware
clock is UTC on every machine :)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php