The TIMESTAMP WITH TIME ZONE datatype stores the date/time : TIMESTAMP « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. TIMESTAMP
SQL>
SQL>
SQL> DECLARE
  2     v_datetime TIMESTAMP (3) WITH TIME ZONE := SYSTIMESTAMP;
  3  BEGIN
  4     DBMS_OUTPUT.PUT_LINE(v_datetime);
  5  END;
  6  /
03-JUN-07 08.51.27.046 PM -07:00

PL/SQL procedure successfully completed.

SQL>








21.7.TIMESTAMP
21.7.1.Using TIMESTAMP
21.7.2.Declaring TIMESTAMP Datatype
21.7.3.TIMESTAMP literals
21.7.4.Using TIMESTAMP WITH TIME ZONE
21.7.5.'TIMESTAMP WITH TIME ZONE' in action
21.7.6.TIMESTAMP WITH LOCAL TIME ZONE
21.7.7.Use select into statement to assign systimestamp to timestamp variable
21.7.8.The TIMESTAMP datatype stores the date/time as follows
21.7.9.The TIMESTAMP WITH TIME ZONE datatype stores the date/time
21.7.10.The TIMESTAMP WITH LOCAL TIME ZONE datatype stores the date/time
21.7.11.Print the current date
21.7.12.Print the current date and timestamp
21.7.13.Two digits for fractional seconds
21.7.14.Nine digits for fractional seconds, 24-hour clock, 14:00 = 2:00 PM
21.7.15.No fractional seconds at all
21.7.16.No time zone, defaults to session time zone