Get started
Load & manage data
Work with data
Administration
Reference & resources
Updated Mar 24, 2023
Send us feedback
date
Applies to: Databricks SQL Databricks Runtime
date(expr)
Casts the value expr to DATE.
expr
expr: An expression that can be cast to DATE.
A DATE.
This function is a synonym for CAST(expr AS expr).
CAST(expr AS expr)
See cast function for details.
> SELECT date('2021-03-21'); 2021-03-21
cast function