Collections:
Out-of-Range DATETIME Values in SQL Server Transact-SQL
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL?
✍: FYIcenter.com
When you enter DATETIME values, you may get out-of-range errors due to two common mistakes:
The tutorial exercise below shows you some data and time out-of-range errors:
-- Invalid date DECLARE @x DATETIME; SET @x = '30-Feb-2017 22:55:07.233'; ----------------------------------- Msg 242, Level 16, State 3, Line 2 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. -- Date below the DATETIME limits DECLARE @x DATETIME; SET @x = '19-May-1752 22:55:07.233'; ----------------------------------- Msg 242, Level 16, State 3, Line 2 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. -- Invalid time DECLARE @x DATETIME; SET @x = '19-May-2017 24:55:07.233'; ----------------------------------- Msg 242, Level 16, State 3, Line 2 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
⇒ Single-Byte Character Data Types in SQL Server Transact-SQL
⇐ Time-Only DATETIME Values in SQL Server Transact-SQL
2017-04-08, 8785🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...