ADD_MONTHS
Adds a specified number of months to a date.
Analyze Syntax
func.add_months(<date>, <months>)
Analyze Examples
func.add_months('2024-01-31', 1)
┌──────────────┐
│ '2024-02-29' │
└──────────────┘
SQL Syntax
ADD_MONTHS(<date>, <months>)
SQL Examples
SELECT ADD_MONTHS('2024-01-31', 1);
┌────────────┐
│ 2024-02-29 │
└────────────┘