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.