VeloDB Cloud 4.x is based on Doris 3.x. Versions in this section refer to Doris versions. See Version Mapping.
DATE
Description
Extracts the date from the datetime.
Syntax
DATE(<datetime>)
Parameters
| Parameter | Description |
|---|---|
<datetime> | A valid date expression |
Return Value
Returns the date part of the datetime.
Examples
select date('2010-12-02 19:28:30');
+----------------------------------------------------+
| date(cast('2010-12-02 19:28:30' as DATETIMEV2(0))) |
+----------------------------------------------------+
| 2010-12-02 |
+----------------------------------------------------+