Get your session time zone using the SESSIONTIMEZONE() function : SESSIONTIMEZONE « Date Timestamp Functions « Oracle PL/SQL Tutorial






SQL>
SQL> SELECT SESSIONTIMEZONE FROM dual;

SESSIONTIMEZONE
---------------------------------------------------------------------------
-07:00

SQL>








13.16.SESSIONTIMEZONE
13.16.1.Get your session time zone using the SESSIONTIMEZONE() function