Oracle PL/SQL/Date Timezone/TZ OFFSET

Find TZ offset for a given region:

 
SQL>
SQL> select tz_offset( "us/eastern")
  2  from dual;
TZ_OFFS
-------
-04:00
1 row selected.
SQL>
SQL> --

Obtaining Time Zone Offsets

SQL> --Obtaining Time Zone Offsets
SQL>
SQL> --TZ_OFFSET() to get the time zone offset hours for PST
SQL>
SQL> SELECT TZ_OFFSET("PST") FROM dual;
TZ_OFFS
-------
-07:00
SQL>