MAKE_DATE

​

Syntax

​

Scalar

make_date(year, month, day)

​

Arguments

​

Returns

• Type: DATE
• NULL behavior: NULL components yield NULL. Default-dialect invalid calendar parts yield NULL. Snowflake out-of-range parts normalize additively; unrepresentable results yield NULL.

​

Properties

​

Examples

​

Leap day

• Use default/non-Snowflake MAKE_DATE semantics; Snowflake MAKE_DATE uses DATE_FROM_PARTS calendar rollover instead.

SELECT make_date(2024, 2, 29) AS result;

​

Invalid default-dialect date

• Use default/non-Snowflake MAKE_DATE semantics; Snowflake MAKE_DATE uses DATE_FROM_PARTS calendar rollover instead.

SELECT make_date(2023, 2, 29) AS result;

​

Limitations

• Dialect selects MAKE_DATE or MAKE_DATE_SF; the same spelling therefore has different invalid-part behavior.
• Use MAKE_DATE. DATE_FROM_PARTS is not an established SQL alias.