TO_TIMESTAMP_TZ('2002-06-18 13:52:00.123456789 -5:00','YYYY-MM-DD HH24:MI:SS.FF TZH:TZM') : TO_TIMESTAMP_TZ « Date Timestamp Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Date Timestamp Functions
3. TO_TIMESTAMP_TZ

SQL> DECLARE
  2     A TIMESTAMP WITH TIME ZONE;
  3     B TIMESTAMP WITH TIME ZONE;
  4     C TIMESTAMP WITH TIME ZONE;
  5  BEGIN
  6     A := TO_TIMESTAMP_TZ('2002-06-18 13:52:00.123456789 -5:00','YYYY-MM-DD HH24:MI:SS.FF TZH:TZM');
  7
  8     DBMS_OUTPUT.PUT_LINE(TO_CHAR(A,'YYYY-MM-DD HH:MI:SS.FF AM TZH:TZM TZR TZD'));
  9  END;
 10  /

PL/SQL procedure successfully completed.

SQL>
SQL>