dateadd function
Applies to: 
Databricks SQL Databricks Runtime
Returns the date numDays after startDate. This function is a synonym for date_add (days) function.
Syntax
dateadd(startDate, numDays)
Arguments
startDate: A DATE expression.numDays: An INTEGER expression.
Returns
A DATE.
If numDays is negative, its absolute value is subtracted from startDate.
If the result date overflows the date range the function raises an error.
To add units other than days, use dateadd(unit, value, expr).
Examples
SQL
> SELECT dateadd('2016-07-30', 1);
2016-07-31