TZ_OFFSET

TZ_OFFSET(time_zone) returns the offset for time_zone in hours and minutes. TZ_OFFSET() function gets the time zone offset hours.

SQL> SELECT TZ_OFFSET('PST')
  2  FROM dual;

TZ_OFFS
-------
-07:00

SQL>