SUBDATE
Subtracts a time interval from a date. Alias for DATE_SUB.
Analyze Syntax
func.subdate(<date>, INTERVAL <n> <unit>)
Analyze Examples
func.subdate('2024-01-31', text('INTERVAL 7 DAY'))
┌──────────────┐
│ '2024-01-24' │
└──────────────┘
SQL Syntax
SUBDATE(<date>, INTERVAL <n> <unit>)
SQL Examples
SELECT SUBDATE('2024-01-31', INTERVAL 7 DAY);
┌────────────┐
│ 2024-01-24 │
└────────────┘