DATEADD
Returns a new datetime value based on adding an interval to the specified date.
Note: This function is equivalent to DATEADD in T-SQL.
Return Value
Date/Time
Syntax
DATEADD( datePart, number, date
)
where:
- datePart is the argument that
specifies on which part of the date to return a new value. Possible values for this
argument include these:
- year, yy, yyyy
- quarter, q, qq
- month, m, mm
- week, wk, ww
- day, d, dd
- weekday, dw
- dayofyear, dy, y
- hour, hh
- minute, mm, n
- second, ss, s
- millisecond, ms
- number is the value used to
increment or decrement the datePart.
To decrement (that is, return an earlier date or time), use a negative number.
If you specify a value that is not an integer, the fractional part of the value is discarded. For example, if you specify day for datePart and 1.75 for number, the date is incremented by 1.
- date is an expression that returns the Date/Time value that you want to change.