Getting started
User guides
Administration guides
Reference guides
Resources
Updated Aug 18, 2022
Send us feedback
date
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