add_months
function
Applies to: Databricks SQL Databricks Runtime
Returns the date that is numMonths
after startDate
.
CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clauseAtualizado 03/12/2024
add_months
function Applies to: Databricks SQL Databricks Runtime
Returns the date that is numMonths
after startDate
.
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