Mega Code Archive
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>