Subject Re: [firebird-support] timestamp trigger?
Author Lester Caine
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 -
Model Engineers Digital Workshop -
Treasurer - Firebird Foundation Inc. -