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