SYS_EXTRACT_UTC

SYS_EXTRACT_UTC(x) converts the TIMESTAMP WITH TIMEZONEx to a TIMESTAMP in UTC.


SQL> SELECT SYS_EXTRACT_UTC(TIMESTAMP '2012-12-17 21:14:21 PST') FROM dual;

SYS_EXTRACT_UTC(TIMESTAMP'2012-12-1721:14:21PST')
---------------------------------------------------------------------------
18-DEC-12 05.14.21.000000000 AM

SQL>
Home »
Oracle »
Timestamp Functions » 

Related: