--- In firebird-support@yahoogroups.com, "Timothy Madden"
<terminatorul@...> wrote:

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

No.

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

If the server makes no adjustments with respect to the timezone
information or daylight savings bias on either the server or the client.

As a convention, I suggest you store the UTC representation of the
time and adjust at the client end. The lack of an in built function
for getting this on the server makes it a bit more of a nuisance when
doing actions in triggers, but if the database server does nothing
else you may be able to set its clock to GMT + 0 as a work around.

Adam