MAKE_TIMESTAMP()

All functions > DATE AND TIME > MAKE_TIMESTAMP()

Builds a TIMESTAMP from a ROW of calendar and clock components.

Signatures

Returns: The constructed TIMESTAMP

MAKE_TIMESTAMP(row: ROW) → TIMESTAMP

Notes

• Required field names are year, month, day, hour, minute, and second (case-insensitive).
• Optional field microsecond adds sub-second precision when present on the ROW type.
• The result is a naive TIMESTAMP (no timezone). To treat the components as local wall time in a zone and convert to UTC storage, wrap with LOCAL_TO_UTC(..., 'IANA_or_offset_name').
• second accepts numeric values; combine microsecond with integer second values when you need explicit microseconds.

Examples

SELECT
    -- Construct a TIMESTAMP without microseconds
    f1 := MAKE_TIMESTAMP(
        ROW(
            2024 AS year,
            3 AS month,
            15 AS day,
            14 AS hour,
            30 AS minute,
            45 AS second
        )
    ),
    -- Local Paris wall time → UTC (CET = UTC+1 in March)
    f2 := LOCAL_TO_UTC(
        MAKE_TIMESTAMP(
            ROW(
                2024 AS year,
                3 AS month,
                15 AS day,
                14 AS hour,
                30 AS minute,
                45 AS second
            )
        ),
        'Europe/Paris'
    )
;