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