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.
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.
Â
