Home Forums SQL Server 7,2000 T-SQL Arithmetic overflow error converting expression to data type datetime. RE: Arithmetic overflow error converting expression to data type datetime.
Steve Jones - SSC Editor
SSC Guru
Points: 734498
More actions
December 5, 2010 at 6:04 pm
#1258864
You are getting an implicit conversion, expecting SQL Server to convert those integer values for you. As Jeff mentioned, you want to use quotes around dates to explicitly state the values are dates and not numbers.