Subject Re: [firebird-support] Re: GMT time in Firebird
Author Timothy Madden
On Wed, Sep 3, 2008 at 6:39 AM, Adam <s3057043@...> 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
>
> Adam
[...]

Thank you for the information.
Does Firebird do any local time translations on the fly if it knows
the client and the server have different local times ?
I would like to know if it stores times in GMT for example and when
a client connects it automatically serves any TIME or DATETIME
value adjusted to that client's local time ?

Thank you,
Timothy Madden