SYS_EXTRACT_UTC(dtz)
extracts the UTC from a datetime value
and returns a value of data type TIMESTAMP
.
dtz is any datetime value with a time zone included.
SQL> SELECT SYS_EXTRACT_UTC(TIMESTAMP '2012-03-25 09:55:00 -04:00') "HQ"
2 FROM DUAL;
HQ
---------------------------------------------------------------------------
25-MAR-12 01.55.00.000000000 PM
SQL>