Oracle Date/Time Function - Oracle/PLSQL SYS_EXTRACT_UTC Function

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.

Example


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>