date(a) + (b,c,[d])
|
Group |
Adds a duration b of unit c to a Date or Timestamp a. If b is negative, the duration will be subtracted from the Date. Subtracting working days is currently not possible, trying to do so will lead to an error. Units are to be given as Integer, digits will be cut off. An addition of e.g. 2.5 hours should be given as 150 minutes. If working days are added, parameter d specifies the Locale to be used for the decision what days are weekends.
Description of Parameters
|
Parameter |
Description |
|
a |
Date to add. |
|
b |
Value to add. |
|
c |
Time unit. |
|
d |
(optional) Locale to be used. Default: de. Note: Use the three dots to select a value. |
Unit Values for Parameter c
|
Value |
Time Unit |
|
milli or S |
Milliseconds. |
|
sec or s |
Seconds. |
|
min or m |
Minutes. |
|
hour or H |
Hours. |
|
day or d |
Days. |
|
month or M |
Months. |
|
year or y |
Years. |
|
workday or w |
Working days. |
Examples
|
Parameter a |
Parameter b |
Parameter c |
Parameter d |
Result |
|
2010-03-01 00:00:00 |
2 |
h |
|
2010-03-01 02:00:00 |
|
2010-03-01 00:00:00 |
-2 |
h |
|
2010-02-28 22:00:00 |
|
2010-03-01 00:00:00 |
5 |
w |
|
2010-03-08 00:00:00 |