In this article we will discuss on How to add Days, Weeks, Months, Quarters or Years to a Date in Sql Server?

You may also like to read the following other popular articles on Date and Time in Sql Server:

• How to get Date Part only from DateTime in Sql Server
• How to get Day, Month and Year Part from DateTime in Sql Server
• Difference between DateTime and DateTime2 DataType
• How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server

How to add Days to DateTime in Sql Server?

We can use DATEADD() function like below to add days to DateTime in Sql Server. DATEADD() functions first parameter value can be day or dd or d all will return the same result. Below example shows how we can add two days to Current DateTime in Sql Server:

SELECT GETDATE() 'Today', 
           DATEADD(day,2,GETDATE()) 'Today + 2 Days'
SELECT GETDATE() 'Today', 
           DATEADD(dd,2,GETDATE()) 'Today + 2 Days'
SELECT GETDATE() 'Today', 
           DATEADD(d,2,GETDATE()) 'Today + 2 Days'

RESULT:

Alternatively, we can add Days to Date like below in Sql Server. In the below example we are add adding 2 days to a DateTime.

SELECT GETDATE() 'Today', GETDATE() + 2 'Today + 2 Days'

RESULT:

How to add Weeks to DateTime in Sql Server?

We can use DATEADD() function to add weeks to DateTime in Sql Server. DATEADD() functions first parameter value can be week or wk or ww, all will return the same result. Below example shows how we can add two weeks to Current DateTime in Sql Server:

SELECT GETDATE() 'Today',
           DATEADD(week,2,GETDATE()) 'Today + 2 Weeks'
SELECT GETDATE() 'Today',
           DATEADD(wk,2,GETDATE()) 'Today + 2 weeks'
SELECT GETDATE() 'Today',
           DATEADD(ww,2,GETDATE()) 'Today + 2 Weeks'

RESULT:

How to add Months to DateTime in Sql Server?

We can use DATEADD() function like below to add Months to DateTime in Sql Server. DATEADD() functions first parameter value can be month or mm or m, all will return the same result. Below example shows how we can add two months to Current DateTime in Sql Server:

SELECT GETDATE() 'Today', 
           DATEADD(month,2,GETDATE()) 'Today + 2 Months'
SELECT GETDATE() 'Today',
           DATEADD(mm,2,GETDATE()) 'Today + 2 Months'
SELECT GETDATE() 'Today',
           DATEADD(m,2,GETDATE()) 'Today + 2 Months'

RESULT:

How to add Quarters to DateTime in Sql Server?

We can use DATEADD() function like below to add Quarters to DateTime in Sql Server. DATEADD() functions first parameter value can be quarter or qq or q, all will return the same result. Below example shows how we can add two months to Current DateTime in Sql Server:

SELECT GETDATE() 'Today',
           DATEADD(quarter,2,GETDATE()) 'Today + 2 Quarters'
SELECT GETDATE() 'Today',
           DATEADD(qq,2,GETDATE()) 'Today + 2 Quarters'
SELECT GETDATE() 'Today',
           DATEADD(q,2,GETDATE()) 'Today + 2 Quarters'

RESULT:

How to add Years to DateTime in Sql Server?

We can use DATEADD() function like below to add Years to DateTime in Sql Server. DATEADD() functions first parameter value can be year or yyyy or yy, all will return the same result. Below example shows how we can add two Years to Current DateTime in Sql Server:

SELECT GETDATE() 'Today',
           DATEADD(year,2,GETDATE()) 'Today + 2 Years'
SELECT GETDATE() 'Today',
           DATEADD(yyyy,2,GETDATE()) 'Today + 2 Years'
SELECT GETDATE() 'Today',
           DATEADD(yy,2,GETDATE()) 'Today + 2 Years'

RESULT:

Also Read:

• How to get Date Part only from DateTime in Sql Server
• How to get Day, Month and Year Part from DateTime in Sql Server
• Difference between DateTime and DateTime2 DataType
• How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server