DATE_ADD function
Returns the date that is num_days after start_date.
Syntax
dateadd(start_date, num_days)
Arguments
- start_date
-
The starting date value.
- num_days
-
The number of days to add (integer). A positive number adds days, a negative number subtracts days.
Return type
DATE
Examples
The following example adds one day to a date:
SELECT dateadd('2016-07-30', 1); Result: 2016-07-31
The following example adds multiple days.
SELECT dateadd('2016-07-30', 5); Result: 2016-08-04
Usage notes
This documentation is for Spark SQL's DATE_ADD function, which provides a simpler interface for adding days to dates compared to some other SQL variants. For adding other intervals like months or years, different functions may be required.
