SQL>SQL>SQL> select EXTRACT(TIMEZONE_MINUTE FROM TO_TIMESTAMP_TZ( 2 '01-JAN-2005 19:15:26 -7:15', 'DD-MON-YYYY HH24:MI:SS TZH:TZM')) 3 AS TZM from dual; TZM---------- -15