SQL query error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL query error

SQL query error

Rate Topic

Display Mode

Topic Options

Author

Message

balasach82

Posted Wednesday, March 06, 2013 6:57 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

select cast(COL1 as datetime) from TABLE where COL1<>'' and isdate(COL1) =1 and
cast(COL1 as datetime) < (DATEADD(YY, -3, GETDATE()))

above query gives the error
Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type datetime.

Any idea why?

Post #1427362

Sean Lange

Posted Wednesday, March 06, 2013 7:28 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 8,608, Visits: 8,252

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1427363-391-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1427392

« Prev Topic | Next Topic »

Permissions