Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Obtaining Time Zone Offsets using the TZ_OFFSET() function
SQL>
SQL> SELECT TZ_OFFSET('PST') FROM dual;
TZ_OFFS
-------
-07:00
SQL>