|
<< Click to Display Table of Contents >>
DATEADD |
Changes a date provided in the @datePart parameter, adding or subtracting the value indicated in the @number parameter to the time unit indicated in the @date parameter.
DATEADD(@datePart, @number, @date)
•@datePart: Indication of a date part, or time unit, that users want to add or subtract. For more information about possible values for this parameter, please check the DATEPART function
•@number: How much users want to change. Positive values add and negative values subtract
•@date: Original date to change
NOTE |
The @datePart parameter of this function does not accept the values iso_week, isowk, or isoww, which are available only for the DATEPART function. |