The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?
silverlight, silverlight-4.0, sql, sql-server-2008
Solution
`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`.
Problem
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.