Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

TIMESTAMP WITH TIME ZONE in action

SQL> SQL> SET SERVEROUTPUT ON SQL> SQL> DECLARE   2     v_timestamp_tz TIMESTAMP WITH TIME ZONE := TIMESTAMP '2004-06-05 22:14:01 +06:00';   3  BEGIN   4     DBMS_OUTPUT.PUT_LINE(v_timestamp_tz);   5  END;   6  / 05-JUN-04 10.14.01.000000 PM +06:00 PL/SQL procedure successfully completed. SQL>