• Register

Related questions

Most popular tags

java python windows networking android sql c c# php mysql javascript r linux operating-system database sql-server program asp net python-3 git node js string function command-line django spring x eclipse macos numpy html ios hibernate json exception reactjs android-studio tensorflow ubuntu arrays operating system gradle ssl microsoft jquery google-chrome pip programming sockets 7 list angular build python-python3-typeerror python-2 maven apache css tomcat spring-mvc wordpress github laravel-5 ggplot2 jdbc mongodb facebook 0 android-gradle-plugin unity3d visual-studio amazon-web-services spring-boot postgresql pandas jpa docker xcode csv dictionary https ssl-certificate laravel

the conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.

0 votes
25 views

Problem :

I am getting bellow error related to datetime
the conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
by (6.9k points)  

1 Answer

0 votes

Solution :

  • I think both the DATETIME and DATETIME2 map to System.DateTime in .NET So you cannot really do a "conversion", as it is really the same .NET type.
  • Also please note that there are two different values for the "SqlDbType" for these two.
  • On SQL Server the date range supported is quite different.
  • DATETIME supports 1753/1/1 to 9999/12/31, while DATETIME2 supports 0001/1/1 through eternity.
  • So what you really need to do is check for the year of the date and if it is before 1753, you need to change it to after 1753 in order for the DATETIME column in SQL Server to handle it.
by (36.1k points)  
...