TO_DAYS
Learn how to use the TO_DAYS date/time function in PlaidCloud Lakehouse. Converts a date to a day count - see syntax, examples, and output.
Converts a date to a day count.
Analyze Syntax
func.to_days(<date>)
Analyze Examples
func.to_days('2024-01-01')
┌────────┐
│ 738886 │
└────────┘
SQL Syntax
TO_DAYS(<date>)
SQL Examples
SELECT TO_DAYS('2024-01-01');
┌────────┐
│ 738886 │
└────────┘