date function (Databricks SQL)

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 (Databricks SQL) for details.

Examples

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