SQL DATEADD Function

The DATEADD function is used to add an interval to a date in MS SQL SERVER

The usage for the DATEADD function is

DATEADD (datepart, number, expression)

where the data type of <expression> is some type of date, time, or datetime. <number> is an integer (can be positive or negative). <datepart> can be one of the following:

datepart	abbreviation
year	yy, yyyy
quarter	qq, q
month	mm, m
dayofyear	dy, y
day	dd, d
week	wk, ww
hour	hh
minute	mi, n
second	ss, s
millisecond	ms
microsecond	mcs
nanosecond	ns
TZoffset	tz
ISO_WEEK	isowk, isoww

The result returned has the same data type as <expression>.

SQL DATEADD Syntax
DATEADD ( datepart , number, date )

Query:SELECT DATEADD(Year, 3, '2012-06-04')

OUTPUT Value = 2015-06-04 00:00:00.000

Query:SELECT DATEADD(Month, 3, '2012-06-04')

OUTPUT Value = 2012-09-04 00:00:00.000

Query:SELECT DATEADD(dayofyear,3, '2012-06-04')

OUTPUT Value = 2012-06-07 00:00:00.000

Query:SELECT DATEADD(Day, 3, '2012-06-04')

OUTPUT Value = 2012-06-07 00:00:00.000

Query:SELECT DATEADD(Week, 3, @DateNow)
OUTPUT Value = 2012-06-25 00:00:00.000

Query:SELECT DATEADD(Hour, 3, @DateNow)
OUTPUT Value = 2012-06-04 03:00:00.000

Query:SELECT DATEADD(minute, 3, @DateNow)
OUTPUT Value = 2012-06-04 00:03:00.000

Query:SELECT DATEADD(second, 3, @DateNow
OUTPUT Value = 2012-06-04 00:00:03.000

Query:SELECT DATEADD(millisecond, 3, @DateNow)
OUTPUT Value = 2012-06-04 00:00:00.003

Returns a new datetime value based on adding an interval to the specified date.