Shulou(Shulou.com)05/31 Report--

Editor to share with you how to solve SqlDateTime overflow, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Error occurred: a "SqlDateTime overflow occurred while importing data. It must be between 1Universe 1753 12:00:00 AM and 12Universe 319999 11:59:59 PM." This problem is mostly due to the datetime type overflow caused by the null datetime field value when you insert or update the database, January 01, 2001, by default.

Cause analysis:

With regard to DateTime, one of the most common errors that occur when inserting the DateTime type into the database: "SqlDateTime overflow. It must be between 1max 1753 12:00:00 AM and 12 DateTime 11:59:59 PM" because when we took the value of DateTime.MinValue and inserted it into the database, the DateTime MinValue value range was inconsistent with the database DateTime type data range. In the database, the field of DateTime type, the minimum value is 1max DateTime 12:00:00, while in .NET Framework, the minimum value of DateTime type is 1pm 110001 0:00:00, obviously, the minimum range of values of Sql is exceeded, resulting in a data overflow error.

Solution:

Use System.Data.SqlTypes.SqlDateTime.MinValue instead of the System.DateTime type, so that the MinValue of SqlDateTime matches the range of DateTime in Sql, and the above error will not occur again.

But if you assign System.Data.SqlTypes.SqlDateTime.MinValue directly to a variable of type System.DateTime, you will get the following error: error 86 cannot implicitly convert type "System.Data.SqlTypes.SqlDateTime" to "System.DateTime". There is an explicit conversion (is there a missing cast?) We can use Convert.ToDateTime to cast.

The above is all the contents of the article "how to solve SqlDateTime spillover". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.