addTime()
for
Schedules Definition Grammar now supports negative offsets: FUNCTION | RETURNED VALUE |
---|---|
addTime(number base_instant, number offset, string schedule_name, timeZone time_zone) : number | Returns the time instant resulting of adding offset milliseconds to base_instant within schedule with name schedule_name for time_zone timezone. Example: addTime(2017/12/01 01:00, 8 * {HOUR} + 31 * {MINUTE}, "my_schedule", LOCAL) returns 2017/12/04 10:01 .Example: addTime(2017/12/04 14:00, 2 * {HOUR} + 30 * {MINUTE}, "my_schedule", LOCAL) returns 2017/12/04 17:00 .Since version 2.2.41 negative offset values are supported: Example: addTime(2017/04/24 09:00, - 2 * {HOUR}, "my_schedule", LOCAL) returns 2017/04/21 14:00 .Example: addTime(2017/04/20 20:30, - 5 * {HOUR}, "my_schedule", LOCAL) returns 2017/04/20 13:00 . |
In the examples above we have used schedule "my_schedule"
, whose definition in
Schedules Definition Grammar is:
Note that 2017/12/01
is Friday, and 2017/12/04
is Monday.
$formatedValue
in column view when returned value was null
. toNumber()
and stringToDate()
threw an exception when input parameter was a null
instead of a string.