Intervals

Interval syntax supports day, hour, minute, second, millisecond, and microsecond values.

Intervals measure the elapsed time between two timestamps, using 64 bits of precision. All occurrences of intervals refer to this definition:

value | {value [ {DAY[S] | {HOUR[S] | HR} | MIN[UTE[S]] | SEC[OND[S]] | {MILLISECOND[S] | MILLIS} | {MICROSECOND[S] | MICROS} ]  [...]}

If only value is specified, the timestamp default is MICROSECOND[S]. You can specify multiple time units by separating each unit with a space, however, you can specify each unit only once. For example, if you specify HOUR[S], MIN[UTE[S]], and SEC[OND[S]] values, you cannot specify these values again in the interval syntax.

Each unit has a maximum value when not combined with another unit:

Time Unit	Maximum Value Allowed
`MICROSECOND[S] \| MICROS`	9,223,372,036,854,775,807
`MILLISECOND[S] \| MILLIS`	9,233,372,036,854,775
`SEC[OND[S]]`	9,223,372,036,854,775
`MIN[UTE[S]]`	153,722,867,280,912
`HOUR[S] \| HR`	2,562,047,788,015
`DAY[S]`	106,751,991,167

These maximum values decrease when you combine units.

Specifying value with a time unit means it must be a positive value. If value is negative, it is treated as an expression. That is, -10 MINUTES in the interval syntax is treated as -(10 MINUTES). Similarly, 10 MINUTES-10 SECONDS is treated as (10 MINUTES)-(10 SECONDS).

The time units can be specified only in CCL. When specifying values for the interval column using the API or adapter, only the numeric value can be specified and is always sent in microseconds.

Examples

3 DAYS, 1 HOUR, 54 MINUTES

2 SECONDS, 12 MILLISECONDS, 1 MICROSECOND