Session Time Zone

The session time zone is the time zone for a particular session. The command to change the session time zone is:

ALTER SESSION SET TIME_ZONE = 'PST'

Set the session TIME_ZONE to LOCAL

ALTER SESSION SET TIME_ZONE = 'LOCAL'

Set the session TIME_ZONE to DBTIMEZONE:

ALTER SESSION SET TIME_ZONE = DBTIMEZONE

To get the session time zone use the SESSIONTIMEZONE function.

SELECT SESSIONTIMEZONE 
FROM dual;

1. What is Time Zone
2. Database Time Zone
3. Session Time Zone
4. Time Zone Names