TO_TIMESTAMP_TZ('2002-06-18 13:52:00.123456789 US/Eastern EDT','YYYY-MM-DD HH24:MI:SS.FF TZR TZD') : 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     B := TO_TIMESTAMP_TZ('2002-06-18 13:52:00.123456789 US/Eastern','YYYY-MM-DD HH24:MI:SS.FF TZR');
  7     C := TO_TIMESTAMP_TZ('2002-06-18 13:52:00.123456789 US/Eastern EDT','YYYY-MM-DD HH24:MI:SS.FF TZR TZD');
  8
  9     DBMS_OUTPUT.PUT_LINE(TO_CHAR(B,
 10        'YYYY-MM-DD HH:MI:SS.FF AM TZH:TZM TZR TZD'));
 11  END;
 12  /

PL/SQL procedure successfully completed.

SQL>
SQL>