SQL/2008   Vendor extension.

Transact-SQL   SMALLDATETIME is supported by Adaptive Server Enterprise. In Adaptive Server Enterprise, the SMALLDATETIME type supports dates between January 1, 1900 and June 6, 2079 and supports less precision with the time portion of the value. In SQL Anywhere, SMALLDATETIME is implemented as a TIMESTAMP without these restrictions. You should be aware of these differences when migrating data between SQL Anywhere and Adaptive Server Enterprise.