Adam wrote:

> --- In firebird-support@yahoogroups.com, "Timothy Madden"
> <terminatorul@...> wrote:
>> Hello
>>
>> Is there a way to get or deduce GMT time from the Firebird server, I
> mean
>> with SQL commands ?
>
> Not directly. You can write / find a UDF to achieve the same thing,
> but that is obviously harder if supporting multiple platforms.
>
> It is in the tracker as an enhancement request.
> http://tracker.firebirdsql.org/browse/CORE-909

The trick currently is to SET the local time on a server to UTC so that all
the times saved are UTC. Since only the client knows what time/daylight saving
zone they are in, only the client application can display the correct local
time. SO even on the server, the DISPLAY of the time needs a UTC/Local switch.

Actually STORING anything other than UTC is the real bug. The offset from UTC
is going to change 6 months of the year in a lot of places so the current
timestamps can give you an hours discrepancy in durations over daylight saving
changes :( But then most sites are not bothered by that as a summer 9AM event
is the same as a winter 9AM event ...

( and browsers only returning a time offset rather than the real time zone
does not help the confusion :) )

--
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