The DateTime type in SQL SERVER is very precise, accurate to seconds and down, which is not necessary for normal systems, so I usually set the date type to Smalldatetime, accurate to minutes, which is always 0 seconds.
\
But it turns out today that it has a range of dates
The 1900-01-01 to 1900-01-01
So a sentence like the following is bound to be an error:
declare @date SMALLDATETIME = ‘2099-01-01’
\
DATETIME:
January 1, 1753, to December 31, 9999
\
\