Sybase Adaptive Server Anywhere - Page 301

Chapter 7 SQL Data Types
283
♦
Sybase Not supported by Adaptive Server Enterprise.
"TIMESTAMP data type" on page 283
TIMESTAMP data type [Date and Time]
The point in time, containing year, month, day, hour, minute, second and
fraction of a second.
TIMESTAMP
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.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise.
"TIME data type" on page 282
See also
Function
Syntax
Usage
Standards and
compatibility
See also