date function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Syntax 

date(expr)

Casts the value expr to DATE.

Arguments

  • expr: An expression that can be cast to DATE.

Returns

A DATE.

This function is a synonym for CAST(expr AS expr).

See cast function for details.

Examples 

> SELECT date('2021-03-21');
 2021-03-21