Procedure in oracle to adjust the time zone?

Asked By 40 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #144140

Procedure in oracle to adjust the time zone?

qa-featured

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.

 

Login/Register to Answer

Related Questions