Examples of converting time zones to character strings : TO_TIMESTAMP_TZ « Date Timestamp Functions « Oracle PL/SQL Tutorial

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

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>
SQL>