DATE
Learn how to use the DATE date/time function in PlaidCloud Lakehouse. Extracts the date part from a datetime expression - see syntax, examples, and output.
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 │
└────────────┘