Interval
From v6.3.1, 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.