New to SQL, having an issue with a calculated date column I want to insert in my query. I want to add 45 days to each date in the OOEXD column. The closest I can get to something working is below. Should I solve for the error message or is there a better syntax ? Thanks
select OOEXD AS [TERM DATE], DATEADD(day, 45, ooexd) AS [45 DAY]
Error: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type datetime.