Oracle PL/SQL Tutorial/Date Timestamp Functions/SESSIONTIMEZONE
Get your session time zone using the SESSIONTIMEZONE() function
<source lang="sql">
SQL> SQL> SELECT SESSIONTIMEZONE FROM dual; SESSIONTIMEZONE
-07:00 SQL></source>
<source lang="sql">
SQL> SQL> SELECT SESSIONTIMEZONE FROM dual; SESSIONTIMEZONE
-07:00 SQL></source>