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

> SELECT dateadd('2016-07-30', 1);
 2016-07-31

Related functions

• date_from_unix_date function
• date_sub function
• dateadd(unit, value, expr)
• datediff function
• months_between function
• timestampadd function