DATETIME data type

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

DATETIME

SQL/2008 Vendor extension.
Transact-SQL DATETIME, rather than TIMESTAMP, is used by Adaptive Server Enterprise. The DATETIME type in Adaptive Server Enterprise supports dates between January 1, 1753 and December 31, 9999 and supports less precision with the time portion of the value. In SQL Anywhere, DATETIME 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.