SEQUENCE()

All functions > DATE AND TIME > SEQUENCE()

Generates an inclusive array of dates or timestamps separated by an interval.

Signatures

Date sequence

Returns: Array of dates or timestamps in the sequence

SEQUENCE(start: DATE | TIMESTAMP, stop: DATE | TIMESTAMP, step: INTERVAL) → ARRAY<DATE> | ARRAY<TIMESTAMP>

Signature notes:

• The INTERVAL step is required — there is no default for temporal types
• Month-based intervals respect calendar month boundaries
• Both start and stop are included when reachable by the given step

Notes

• Generates sequence from start to stop inclusive
• For integers: step defaults to 1; use a negative step for descending sequences
• For dates and timestamps: the INTERVAL step is required (no default)
• Month-based intervals (e.g. 1 month) respect calendar month boundaries
• If start equals stop the result contains exactly one element

Aliases

• RANGE

• GENERATE_SERIES

See also

• Array functions

Examples

Integer sequences

SELECT
    f1 := SEQUENCE(1, 5), -- Default step 1
    f2 := SEQUENCE(5, 1, -1), -- Descending with negative step
    f3 := SEQUENCE(3, 3) -- Single-point range
;

Date sequences

SELECT
    f1 := SEQUENCE(DATE '2024-01-01', DATE '2024-01-05', INTERVAL_PARSE('1 day')), -- Day-by-day sequence
    f2 := SEQUENCE(DATE '2024-01-31', DATE '2024-04-30', INTERVAL_PARSE('1 month')) -- Monthly steps respect calendar boundaries (leap year Feb)
;

Timestamp sequences

SELECT
    f1 := SEQUENCE(TIMESTAMP '2024-03-01 00:00:00', TIMESTAMP '2024-03-01 06:00:00', INTERVAL_PARSE('2 hours')) -- Two-hour steps within a single day
;