Timezone Problem

[frasernm]

Hi,

I've got a (fairly large) perl web-based application with an Oracle 9i back-end. The database has been hosted in the UK (with GMT time), but is about to be moved to Holland (CET time, so 1hr ahead). Every time we use systimestamp/sysdate it's one hour ahead, and it's producing wrong results in many pages. Is there any quick fix I can use to get GMT time from the database. We make heavy use of sysdate/systimestamp in our queries, but have limited priviledges on the database.

TIA

Fraser

 

[revnice]

Is there some way you can add a function to the queries which converts sysdate to sysdate -1 on the fly?

revnice

 

[Naith]

You probably have your timezone set to GMT on the box the db is sitting on, when it should be set to BST.

Either change the TZ variable on your box, or reference BST on the db.

Naith