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'
SELECT GETDATE() 'Today', GETDATE() + 2 'Today + 2 Days'
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'
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'
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'
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'
No comments:
Post a Comment