MAKE_INTERVAL()

All functions > DATE AND TIME > MAKE_INTERVAL()

Builds an INTERVAL from a ROW of duration components.

Signatures

Returns: The constructed INTERVAL

MAKE_INTERVAL(row: ROW) → INTERVAL

Notes

• The ROW must expose exactly these names (case-insensitive): years, months, weeks, days, hours, minutes, seconds, milliseconds, microseconds.
• Omit unused units with zero or NULL in the ROW expression as needed.
• Components are combined on the SQL side into a single INTERVAL value.

Examples

SELECT
    -- Construct an INTERVAL from parts
    f1 := TO_ISO8601(
        MAKE_INTERVAL(
            ROW(
                1 AS years,
                0 AS months,
                0 AS weeks,
                2 AS days,
                3 AS hours,
                0 AS minutes,
                0 AS seconds,
                0 AS milliseconds,
                0 AS microseconds
            )
        )
    )
;