Interval Literal
A literal that represents a time span.
Syntax
[ @ ] [-] { quantity subtype-unit }[...] [ AGO ]
Parameters
@
|
Ignored |
- (minus)
|
Specifies a negative interval value. |
quantity | Integer numeric constant |
subtype‑unit | See Interval Subtype Units for valid values. Subtype units must be specified for year-month intervals; they are optional for day-time intervals. |
AGO
|
Specifies a negative interval value. AGO and - (minus) are synonymous. |
Notes
- The amounts of different units are implicitly added up with appropriate sign accounting.
-
The boundaries of an interval constant are:
9223372036854775807 usec
to‑9223372036854775807 usec
296533 years 3 mons 21 days 04:00:54.775807
to‑296533 years ‑3 mons ‑21 days ‑04:00:54.775807
- The range of an interval constant is
+/– 263 – 1
microseconds. - In Vertica, interval fields are additive and accept large floating-point numbers.