SYS_EXTRACT_UTC(x) converts the TIMESTAMP WITH TIMEZONE x to a TIMESTAMP containing the date and time in UTC. : SYS_EXTRACT_UTC « Date Timestamp Functions « Oracle PL/SQL Tutorial
13. 19. 1. SYS_EXTRACT_UTC(x) converts the TIMESTAMP WITH TIMEZONE x to a TIMESTAMP containing the date and time in UTC.
SQL>
SQL> SELECT SYS_EXTRACT_UTC(TIMESTAMP '2005-05-13 19:15:26 PST') FROM dual;
SYS_EXTRACT_UTC(TIMESTAMP'2005-05-1319:15:26PST')
---------------------------------------------------------------------------
14-MAY-05 02.15.26.000000000 AM
SQL>
13. 19. SYS_EXTRACT_UTC
13. 19. 1.
SYS_EXTRACT_UTC(x) converts the TIMESTAMP WITH TIMEZONE x to a TIMESTAMP containing the date and time in UTC.