>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
