Contents Index TIME data type [Date and Time] Binary data types

ASA SQL Reference
  SQL Data Types
    Date and time data types

TIMESTAMP data type [Date and Time]


Function 

The point in time, containing year, month, day, hour, minute, second and fraction of a second.

Syntax 

TIMESTAMP

Usage 

The fraction is stored to 6 decimal places. A TIMESTAMP value requires 8 bytes of storage.

Although the range of possible dates for the TIMESTAMP data type is the same as the DATE type (covering years 0001 to 9999), the useful range of TIMESTAMP date types is from 1600-02-28 23:59:59 to 7911-01-01 00:00:00. Prior to, and after this range the time portion of the TIMESTAMP may be incomplete.

Standards and compatibility 
See also 

TIME data type [Date and Time]


Contents Index TIME data type [Date and Time] Binary data types