DATE
Extracts the date part from a datetime expression.
Analyze Syntax
func.date(<datetime>)
Analyze Examples
func.date('2024-06-15 14:30:00')
┌──────────────┐
│ '2024-06-15' │
└──────────────┘
SQL Syntax
DATE(<datetime>)
SQL Examples
SELECT DATE('2024-06-15 14:30:00');
┌────────────┐
│ 2024-06-15 │
└────────────┘