Subject Re: [firebird-support] Re: Firebird 1.5 - CURRENT_TIMESTAMP difference
Author Mark Rotteveel
On 14 Dec 2014 14:14:21 -0800, "emadour@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
> Unfortunately we're using 1.5 so "NOW" isn't available to us.
>
> We're running the statements in real-time so a 30 minute difference is
> definitely wrong.. It is also exactly 30 minutes which leads me to
believe
> there's some kind of funny offset due to timezone or something to that
> effect that we aren't seeing for whatever reason. I thought if I
figured
> out where the "CURRENT_TIMESTAMP" statement is pulling its time from I
> would know where to look for the issue.

Do you also get this 30 minute difference if you execute SELECT
CURRENT_TIMESTAMP FROM RDB$DATABASE from ISQL and/or Flamerobin, or only
inside your application?

What is your own timezone, and what is the server timezone?

Mark