Procedure in oracle to adjust the time zone?

Asked By Edward Rand 40 points N/A Posted on - 11/23/2012

Hello,

I am new to Oracle. We now use Oracle 11g. I would appreciate some help on how to adjust the time zone. For example suppose it set to GMT -04:00. How can I change it to reflect GMT+05:30. 

Please indicate the procedure in oracle to adjust time zone.

Thanks.

• Status: Open
• Question Views: 991
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By jeffe meeks 0 points N/A #144140

Procedure in oracle to adjust the time zone?

Hi,

Oracle has a default time zone settings. You can check it by typing this command :

SELECT SESSIONTIMEZONE FROM DUAL ;

If you should to change the database time zone, you have to insert the ALTER command as follow :

SQL> ALTER database SET TIME_ZONE = 'India’;
Database altered.

So you can notice that the date/time for your Oracle Job is taken directly from your operating system. To get the right time, you have to fix your operating system time zone.

 

About jeffe meeks

Questions
3

Answers
100

Best Answers
22

• Vote Up 0 Vote Down

• Posted on - 11/23/2012
• Question Category: Oracle Database