make_date
function
Applies to: Databricks SQL Databricks Runtime
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.
In Databricks SQL, if any of the arguments is out of bounds, the result is NULL
.
In Databricks Runtime, if any of the arguments are out of bounds, the function returns an error unless spark.sql.ansi.enabled is false
, in which case the function returns 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