alter the session with the ALTER SESSION statement and set the session's 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>