SQL Server DATEADD use of date functions

DATEADD Date Function

The DATEADD () function adds or subtracts a specified time interval from a date.

Day:
Add two days to the current date

Select DATEADD (Day,2,'2014-12-30')-  on Select DATEADD (DD,2,'2014-12-30'

Month:
Add two months to the current date

Select DATEADD(MM,2,'2014-12-30'Results -- Geneva- - Select DATEADD(MONTH,2,'2014-12-30'Results -- Geneva- - 

Years:
Add two years to the current date

Select DATEADD(YY,2,'2014-12-30'Results .- A- - Select DATEADD( Year,2,'2014-12-30'Results .- A- -

Grammar

DATEADD (Datepart,number,date)
The date parameter is a valid day expression. Number
is the number of intervals you want to add; for future time, this number is positive, and for the past time, this number is negative.

The datepart parameter can be the following value:
DatePart abbreviation
Year yy, yyyy
Quarterly QQ, Q
month mm, M
The day of the year dy, y
Day DD, D
Zhou Wk, ww
Week DW, W
Hour HH
Minutes mi, n
SEC SS, S
Ms MS
Subtle MCs
nanosecond NS

SQL Server DATEADD use of date functions