SYS_EXTRACT_UTC
SYS_EXTRACT_UTC(x)
converts the TIMESTAMP WITH TIMEZONE
x 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>