Date Add
Returns the result of adding the specified number (which may be negative) of date part intervals to the specified date, and returns a string representing the resulting date/time.
Arguments
This function has the following arguments:
Date: Text string specifying the date to which is added the specified number of date parts. This must be either a formatted date/time string or a Java standard date/time argument in milliseconds from Jan 1, 1970.
Number: Numeric value. The number of date parts to add to the specified date.
Date Part: Text string specifying the date part, the specified number of which are to be added to the specified date. Specify
s,
m,
h,
d,
w,
M,
q or
y for seconds, minutes, hours, days, weeks, months, quarters, or years.
Date Format: Text string specifying the format of the function result. Specify a pattern string suitable for use with the Java
SimpleDateFormat class. For example, the format
MMMM dd, yyyy hh:mm:ss a results in dates of the form exemplified by
August 30, 2003 05:32:12 PM. If no
Date Format is given, the string is returned in the form exemplified by
08/30/03 05:32 PM. Use
q,
qqq or
qqqq for short, medium or long versions of quarter notation. For example,
qqq-yyyy results in a string of the form exemplified by
Qtr 1-2005.
The function returns a text string.