Nine digits for fractional seconds, 24-hour clock, 14:00 = 2:00 PM : TIMESTAMP « PL SQL Data Types « Oracle PL/SQL Tutorial






SQL> DECLARE
  2     a TIMESTAMP WITH TIME ZONE;
  3     b TIMESTAMP WITH TIME ZONE;
  4     c TIMESTAMP WITH TIME ZONE;
  5     d TIMESTAMP WITH TIME ZONE;
  6     e DATE;
  7  BEGIN
  8
  9
 10     b := TIMESTAMP '2002-02-19 14:00:00.000000000 -5:00';
 11
 12  END;
 13  /

PL/SQL procedure successfully completed.

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