Hi Garrett,

I don't know if there is a native call, but if there isn't you could
always create a UDF function TimestampToGMT that converts the time to
GMT.

Then instead of saying

where MyTime > CURRENT_TIMESTAMP-1

you could say

where MyTime > TimestampToGMT(CURRENT_TIMESTAMP)-1


--- In firebird-support@yahoogroups.com, "Garrett Smith"
<garrett@m...> wrote:

> Is there a way to tell Firebird (in my case, embedded FB) to use a
> specific timezone when creating values via CURRENT_TIMESTAMP (and

the

> other CURRENT functions)?
>
> We store all dates in GMT and it's a pain to factor in the machine

time

> zone offset when writing queries that use the CURRENT functions.
>
> -- Garrett