Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Examples of converting time zones to character strings

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>