MAKE_DATE()

All functions > DATE AND TIME > MAKE_DATE()

Builds a DATE from a ROW of calendar components.

Signatures

Returns: The constructed DATE

MAKE_DATE(row: ROW) → DATE

Notes

• The ROW must use the field names year, month, and day (case-insensitive).
• Each component is passed through to the SQL backend's date constructor for the active dialect.

Examples

SELECT
    f1 := MAKE_DATE(ROW(2024 AS year, 3 AS month, 15 AS day)) -- Construct a DATE from parts
;