Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to set timezone for database different from OS

kendennyMay 4 2015 — edited May 5 2015

We have a database that is currently residing in New York. We are going to be moving to another server which resides in London. This presents a problem because every date that's currently in the database the time is New York time, but after the move all new data that's created the time will be London time. We don't want users to have to remember that any date prior to the move date the time will be off by 5 hours so what we'd like to do is to have the database still on New York time despite the OS being London time. The server will be shared with other applications so the OS timezone will have to remain London time. The database will have only the data for our application. So is there a database parameter we can use to set the database time zone different from the OS time zone? The database is currently 10g but will be upgraded to 11g as part of the move.

This post has been answered by John Stegeman on May 4 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2015
Added on May 4 2015
15 comments
3,974 views