 
 
 ![DATE data type [Date and Time]](gif/backward.gif) 
 ![SMALLDATETIME data type [Date and Time]](gif/forward.gif) 
 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]
 
 
 ![DATE data type [Date and Time]](gif/backward.gif) 
 ![SMALLDATETIME data type [Date and Time]](gif/forward.gif)