Interval
A new attribute type, Interval, represents time intervals and durations. For example, the interval value
01:25:40
represents a duration of one hour, twenty-five minutes, and forty seconds. The duration
01:30
represents one minute and thirty seconds. The duration
1h30
represents one hour and thirty minutes. A duration may be preceded by a number of days:
1 day 01:00:00
(25 hours)
2d2h30
(two days, two hours and 30 minutes)
An interval may have negative duration:
-5:30
The default value for intervals is the string "00:00".
Intervals may be added or subtracted from durations, multiplied or divided by constants or numeric attributes, and may be compared for equality using == and != or for magnitude using < and >. Interval may be added to dates. Note that subtracting two dates does not currently return an interval; rather, it returns the number of days between the two dates.
The interval "2d5" is treated as 2 days, 5 hours.
The interval "1h30m10s" is treated as one hour, thirty minutes and 10 seconds.
From v8.2.1, the result of applying a binary operation where the left-hand side is a string and the right-hand side is an interval is now a string: previously resulted in an interval. Thus adding an interval to a string:
"The answer is:" + $MyNumber
returns a string.