make_date function (Databricks SQL)

Creates a date from year, month, and day fields.

Syntax

make_date(year, month, day)

Arguments

  • year: An INTEGER expression evaluating to a value from 1 to 9999.

  • month: An INTEGER expression evaluating to a value from 1 (January) to 12 (December).

  • day: An INTEGER expression evaluating to a value from 1 to 31.

Returns

A DATE.

If any of the arguments is out of bounds, the result is NULL.

Examples

> SELECT make_date(2013, 7, 15);
 2013-07-15
> SELECT make_date(2019, 13, 1);
 NULL
> SELECT make_date(2019, 7, NULL);
 NULL
> SELECT make_date(2019, 2, 30);
 NULL