date function
Applies to: 
Databricks SQL Databricks Runtime
This function is a synonym for CAST(expr AS expr). See cast function for details.
Syntax
date(expr)
Casts the value expr to DATE.
Arguments
expr: An expression that can be cast to DATE.
Returns
A DATE.
Examples
SQL
> SELECT date('2021-03-21');
2021-03-21