Oracle PL/SQL Tutorial/Date Timestamp Functions/TZ OFFSET
Obtaining Time Zone Offsets using the TZ_OFFSET() function
<source lang="sql">
SQL> SQL> SELECT TZ_OFFSET("PST") FROM dual; TZ_OFFS
-07:00 SQL> SQL></source>
<source lang="sql">
SQL> SQL> SELECT TZ_OFFSET("PST") FROM dual; TZ_OFFS
-07:00 SQL> SQL></source>