add_months
function
Applies to: Databricks SQL Databricks Runtime
Returns the date that is numMonths
after startDate
.
add_months(startDate, numMonths)
startDate
: A DATE expression.numMonths
: An integral number.
A DATE. If the result exceeds the number of days of the month the result is rounded down to the end of the month. If the result exceeds the supported range for a date an overflow error is reported.
> SELECT add_months('2016-08-31', 1);
2016-09-30
> SELECT add_months('2016-08-31', -6);
2016-02-29