SQL DATEADD Function

This example adds 1 year to a date.

SELECT DATEADD(year, 1, '2021-09-25') AS 'Year Later'

A common use is to add or subtract time from the current date.
In this example, 2 weeks are substracted.

SELECT DATEADD(week, -2, GETDATE()) AS '2 Weeks Ago'

Syntax of the DATEADD function .

DATEADD(date_part, value, input_date) 

These are valid date_part values with possible abbreviations

 SELECT FirstName, LastName, OrderNumber, 
        DATEADD(day, 3, OrderDate) AS 'Shipping Date'
   FROM [Order] O
   JOIN Customer C ON O.CustomerId = C.Id

FirstName	LastName	OrderNumber	Shipping Date
Paul	Perrier	542378	2012-07-07 00:00:00.000
Karin	Josephs	542379	2012-07-08 00:00:00.000
Mario	Pontes	542380	2012-07-11 00:00:00.000
Mary	Saveley	542381	2012-07-11 00:00:00.000
Pascale	Cartrain	542382	2012-07-12 00:00:00.000

 SELECT FirstName, LastName, OrderNumber, 
        DATEADD(month, 1, OrderDate) AS 'Last Return Date'
   FROM [Order] O
   JOIN Customer C ON C.Id = O.CustomerId

FirstName	LastName	OrderNumber	Last Return Date
Paul	Perrier	542378	2012-08-04 00:00:00.000
Karin	Josephs	542379	2012-08-05 00:00:00.000
Mario	Pontes	542380	2012-08-08 00:00:00.000
Mary	Saveley	542381	2012-08-08 00:00:00.000
Pascale	Cartrain	542382	2012-08-09 00:00:00.000

• Our SQL Date Functions Reference
• Our Sql DATEDIFF Function Reference
• Our Sql DATEDIFFBIG Function Reference