Subject Re: Time zone offset in select
Author Adam
--- In firebird-support@yahoogroups.com, Jiri Cincura <diskuze@...> wrote:
>
> Hi *,
>
> is there any option how to retrieve in FB the time zone offset
setted on
> computer? I need to work with UTC/GMT time so I need the offset.
>
> If there's no way ho to do this, I'll have to add some constant with
this
> value. But the problem is, that in here in Europe/Czech Rep. we have
Summer
> Time and "normal time" (winter). Normal is GMT+1 and summer is
normal+1 as
> expected.
>
> Thanks for any solutions.

The best I have found to date is to create a UDF function that returns
UTC time. I too would love such a function built into the engine, but
as far as I am aware, it is not currently available.

Adam