Ann W. Harrison wrote:

> Fernando Salaices wrote:
>> a generator? Can a generator be created that returns the current date?
>
> Not a date, but a more reliable ordering. If you use timestamps, how
> do you handle the transition from daylight savings time to standard
> time when suddenly time (local time) goes backward?

You have to run the server at UTC time as it's the only way currently
to match 'NOW' on other databases ;)

A generator is no use when what you are trying to log is WHEN a
transaction happened and as you have pointed out timestamps are not
consistent. We DO need a UTC_NOW so that times are in chronological even
if the clients are in different time zones :)

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php