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.

Examples

See Specifying Interval Input.