Sean Lange (2/15/2013)
You should use DATEADD because the simple math does not work with date or datetime2 datatypes.
I have to ask... if you're not using the DATE or DATETIME2 datatypes, why does that matter?
--Jeff Moden
Change is inevitable... Change for the better is not.