>Hey guys,
>
>I'm having some issues with a time difference on a server - the software we've built around Firebird checks that the client and server do not have a
>time different of more than 30 minutes otherwise certain functionality is disabled.
>
>Now the server time is fine, but when querying Firebird it reports a half hour difference compared to what Windows is displaying. What I'd love to know
>is where does Firebird get that time from? What is it calling to return that timestamp? I've checked all the regular windows locations (registry,
>regions, timeserver etc..) but there's no trace of that time.
>
>The OS is Windows Server 2003 and this is the only instance of this issue I've seen.

According to http://www.firebirdfaq.org/faq114/, CURRENT_TIMESTAMP returns the time at statement start. Could that explain your deviation and do you observe the same problem if you use 'now'?

Set