SMALLDATETIME data type

SMALLDATETIME is a domain, implemented as TIMESTAMP, used to store date and time of day information. SMALLDATETIME is a Transact-SQL type.

SMALLDATETIME

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.

Discuss this page in DocCommentXchange.