Subject | RE: [firebird-support] Re: Firebird 1.5 - CURRENT_TIMESTAMP difference |
---|---|
Author | Bogdan |
Post date | 2014-12-15T08:26:10Z |
Sent: Monday, December 15, 2014 8:50 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Firebird 1.5 - CURRENT_TIMESTAMP difference
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.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
The last time i've seen such behaviour, we found there was another job scheduled every 30 minutes
that took all the resources
Regards
Bogdan
E-pošta je čista. Ne vsebuje virusov in zlonamerne programske kode. avast! Antivirusna zaščita je aktivna. Prenesite si avast! Antivirusno zaščito iz www.avast.si. |