Using TIMESTAMP : TIMESTAMP « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. TIMESTAMP

Simple TIMESTAMP allows you to specify fractions of a second.

DATE precision is limited to seconds.

declare
    variable1_ts TIMESTAMP[(precision)];
begin
    NULL;
end;

Oracle stores 6 digits of precision, but you can specify precision within the range from 0 to 9.

TIMESTAMP(0) is equivalent to DATE.




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