sql - The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?

Question

I am working on application contains a datepicker and if I set the time in that picker to a very old value or far in the future when I try to save this value in the database the server throw this exception, what is the cause of it?

The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.

Answer 1

DateTime has the range: January 1, 1753, through December 31, 9999

DateTime2 has the range: 0001-01-01 through 9999-12-31

So if you are entering a date before 1753 you would get this error when the field in the table is of type DateTime.