Interval syntax supports day, hour, minute, second, millisecond, and microsecond values.
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.
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 |
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.
3 DAYS, 1 HOUR, 54 MINUTES
2 SECONDS, 12 MILLISECONDS, 1 MICROSECOND