Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. EXTRACT(TIMEZONE_MINUTE FROM TO_TIMESTAMP_TZ(01-JAN-2005 19
SQL>  SELECT
  2    EXTRACT(TIMEZONE_MINUTE FROM TO_TIMESTAMP_TZ(
  3      '01-JAN-2005 19:15:26 -7:15', 'DD-MON-YYYY HH24:MI:SS TZH:TZM'))
  4      AS TZM
  5  FROM dual;
       TZM
----------
       -15
SQL>