SYS_EXTRACT_UTC(x): convert the TIMESTAMP WITH TIMEZONE x to a TIMESTAMP containing the date and time in UTC : SYS_EXTRACT_UTC « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. SYS_EXTRACT_UTC

SYS_EXTRACT_UTC(x): convert the TIMESTAMP WITH TIMEZONE x to a TIMESTAMP containing the date and time in UTC

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>
           
       

Related examples in the same category