Oracle PL/SQL/System Tables Views/SYS EXTRACT UTC

Материал из SQL эксперт
Перейти к: навигация, поиск

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>
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/SYS_EXTRACT_UTC&oldid=2212»