Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

Alter the session with the ALTER SESSION statement and set the sessions time zone forward

SQL> SQL> ALTER SESSION SET TIME_ZONE = '+9:00'; Session altered. SQL> Session altered. SQL> SQL> SELECT   2     DBTIMEZONE     db_time,   3     SESSIONTIMEZONE   session_time   4  FROM dual; DB_TIM SESSION_TIME ------ --------------------------------------------------------------------------- +00:00 +09:00 SQL>