Oracle PL/SQL Tutorial/Date Timestamp Functions/TZ OFFSET

Obtaining Time Zone Offsets using the TZ_OFFSET() function

SQL>
SQL> SELECT TZ_OFFSET("PST") FROM dual;
TZ_OFFS
-------
-07:00
SQL>
SQL>