Subject | Re: [firebird-support] Re: Firebird 1.5 - CURRENT_TIMESTAMP difference |
---|---|
Author | Mark Rotteveel |
Post date | 2014-12-15T07:50:01Z |
On 14 Dec 2014 14:14:21 -0800, "emadour@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
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
<firebird-support@yahoogroups.com> wrote:
> Unfortunately we're using 1.5 so "NOW" isn't available to us.believe
>
> 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
> there's some kind of funny offset due to timezone or something to thatfigured
> effect that we aren't seeing for whatever reason. I thought if I
> out where the "CURRENT_TIMESTAMP" statement is pulling its time from IDo you also get this 30 minute difference if you execute SELECT
> would know where to look for the issue.
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