Randolph West continues a series on date and time types in SQL Server with the DATEADD function:
As with similar functions,
DATEADDcan do arithmetic on dates as well as times. The syntax is straightforward:
DATEADD (datepart, number, date)The
numberportion must be an integer, and it must be within the acceptable range of values for the date part.
Click through for a few examples.