Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

SYS_EXTRACT_UTC(x)

SQL> SQL> --SYS_EXTRACT_UTC(x): convert 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>