Subject Firebird 1.5 - CURRENT_TIMESTAMP difference
Author

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.


Thanks in advance.