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

by

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.

More Related Contents:

  1. to select all the employees who have joined most recently under king
  2. Unpivot with column name
  3. How can I delete using INNER JOIN with SQL Server?
  4. Convert varchar into datetime in SQL Server
  5. sql query to return differences between two tables
  6. SQL Joins Vs SQL Subqueries (Performance)?
  7. Check if a row exists, otherwise insert
  8. How to do pagination in SQL Server 2008
  9. formula for computed column based on different table’s column
  10. SQL comments on create table on SQL Server 2008
  11. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  12. How to write UPDATE SQL with Table alias in SQL Server 2008?
  13. SQL Server 2008- Get table constraints
  14. Restrict an SQL Server connection to a specific IP address
  15. How does this CASE expression reach the ELSE clause?
  16. SQL Server: Cannot insert an explicit value into a timestamp column
  17. Execute Dynamic Query with go in sql
  18. is of a type that is invalid for use as a key column in an index
  19. TransactSQL to run another TransactSQL script
  20. Conditional logic in PostDeployment.sql script using SQLCMD
  21. How can I get a list of element names from an XML value in SQL Server
  22. Why are logical reads for windowed aggregate functions so high?
  23. How can I group time by hour or by 10 minutes?
  24. Custom function with check constraint SQL Server 2008
  25. How to rename something in SQL Server that has square brackets in the name?
  26. Comma Separated values with SQL Query
  27. how to separate string into different columns?
  28. How to count in SQL all fields with null values in one record?
  29. Restrict varchar() column to specific values?
  30. Using CASE Statement inside IN Clause

Leave a Comment