ASA SQL Reference
SQL Data Types
Date and time data types
A domain, implemented as TIMESTAMP.
DATETIME
DATETIME is provided primarily for compatibility with Adaptive Server Enterprise.
SQL/92 Vendor extension.
Sybase Compatible with Adaptive Server Enterprise. For an exception, see Transact-SQL compatibility of string-to-date/time conversions.
DATE data type [Date and Time]
SMALLDATETIME data type [Date and Time]
TIMESTAMP data type [Date and Time]