N/APosted on - 11/23/2012
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.
Procedure in oracle to adjust the time zone?
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’;
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.