Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
> SELECT dateadd('2016-07-30', 1);
2016-07-31