ADDDATE
Learn how to use the ADDDATE date/time function in PlaidCloud Lakehouse. Adds a specified time interval to a date. Alias for
DATE_ADD.Adds a specified time interval to a date. Alias for DATE_ADD.
Analyze Syntax
func.adddate(<date>, INTERVAL <n> <unit>)
Analyze Examples
func.adddate('2024-01-01', text('INTERVAL 7 DAY'))
┌──────────────┐
│ '2024-01-08' │
└──────────────┘
SQL Syntax
ADDDATE(<date>, INTERVAL <n> <unit>)
SQL Examples
SELECT ADDDATE('2024-01-01', INTERVAL 7 DAY);
┌────────────┐
│ 2024-01-08 │
└────────────┘