datetime (Transact-SQL)

Property Value Syntax datetime Usage DECLARE @MyDatetime datetime CREATE TABLE Table1 ( Column1 datetime) Default string literal formats (used for down-level client) Not applicable Date range January 1, 1753, through December 31, 9999 Time range 00 ...

msdn.microsoft.com