On 14 Dec 2014 14:14:21 -0800, "emad...@yahoo.com.au [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