DATE_SUB
Subtracts a specified time interval from a date or datetime.
Analyze Syntax
func.date_sub(<date>, INTERVAL <n> <unit>)
Analyze Examples
func.date_sub('2024-03-01', text('INTERVAL 1 MONTH'))
┌──────────────┐
│ '2024-02-01' │
└──────────────┘
SQL Syntax
DATE_SUB(<date>, INTERVAL <n> <unit>)
SQL Examples
SELECT DATE_SUB('2024-03-01', INTERVAL 1 MONTH);
┌────────────┐
│ 2024-02-01 │
└────────────┘