Generally this error occurs when we are inserting the value is less than 1753, so SQL Server DATETIME cannot store it.
Solution:
Change the Datatype from DATETIME to DATETIME2
Error: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Prabhakaran
I have over 10+ years of industry experience as Creative visualization professional, and have been a part of Web development, Web design, graphic designing, branding and typography projects for many exceptional companies during these years.
Leave a Reply