The SQL DATEADD() function is used to add or subtract a time interval to a date.
The DATEADD() function is supported in SQL Server. In MySQL, it has similar function SQL ADDDATE().
SQL DATEADD Syntax
DATEADD(datepart,number,date-expression)
datepart | Abbreviation |
---|---|
year | yyyy,yy |
quarter | qq,q |
month | mm,m |
dayofyear | dy,y |
day | dd,d |
week | ww,wk |
weekday | dw,w |
hour | hh |
minute | mi,n |
millisecond | ms |
microsecond | mcs |
nanosecond | ns |
SQL DATEADD Examples
Get next year’s date:
SELECT DATEADD(yyyy,1,GETDATE()) AS [Next Year]
The result will look like:
Next Year |
---|
2012-09-04 21:21:42.320 |
Get the date after 90 days:
SELECT DATEADD(dd,90,GETDATE()) AS [90 Days]
The result will look like:
90 Days |
---|
2011-12-03 21:23:20.260 |
Get the date 4 weeks before:
SELECT DATEADD(ww,-4,GETDATE()) AS [4 Weeks Before]
The result will look like:
4 Weeks Before |
---|
2011-08-07 21:24:55.773 |
Get the date 12 hours before:
SELECT DATEADD(hh,-12,GETDATE()) AS [12 Hours Before]
The result will look like:
12 Hours Before |
---|
2011-09-04 09:26:17.413 |