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