MONTHS_SUB
Subtracts a specified number of months from a date.
Analyze Syntax
func.months_sub(<date>, <n>)
Analyze Examples
func.months_sub('2024-06-15', 3)
┌──────────────┐
│ '2024-03-15' │
└──────────────┘
SQL Syntax
MONTHS_SUB(<date>, <n>)
SQL Examples
SELECT MONTHS_SUB('2024-06-15', 3);
┌────────────┐
│ 2024-03-15 │
└────────────┘