DATEDIFF
Learn how to use the DATEDIFF date/time function in PlaidCloud Lakehouse. Returns the number of days between two dates - see syntax, examples, and output.
Returns the number of days between two dates.
Analyze Syntax
func.datediff(<end_date>, <start_date>)
Analyze Examples
func.datediff('2024-03-01', '2024-01-01')
┌────┐
│ 60 │
└────┘
SQL Syntax
DATEDIFF(<end_date>, <start_date>)
SQL Examples
SELECT DATEDIFF('2024-03-01', '2024-01-01');
┌────┐
│ 60 │
└────┘