ADD_DAYS

Description

The ADD_DAYS function is used to add numDays days to the given date startDate, returning a new date. If the calculation result exceeds the date range supported by the system, it returns null.

Function Syntax

add_days(startDate, numDays)

Parameter Description

• startDate: Date type, represents the start date.
• numDays: Integer type, represents the number of days to add.

Return Result

Returns a new date, date type.

Usage Example

1. Example of adding days:

   SELECT add_days('2020-05-31', 10);
   +----------------------------+
   | add_days('2020-05-31', 10) |
   +----------------------------+
   | 2020-06-10                 |
   +----------------------------+
   

2. Example of Reducing Days:

   SELECT add_days('2020-05-31', -3);
   +----------------------------+
   | add_days('2020-05-31', -3) |
   +----------------------------+
   | 2020-05-28                 |
   +----------------------------+
   

3. Example of Cross-Year Date Calculation:

   SELECT add_days('2020-12-31', 365);
   +-----------------------------+
   | add_days('2020-12-31', 365) |
   +-----------------------------+
   | 2021-12-31                  |
   +-----------------------------+
   

4. Example of Exceeding Date Range:

   SELECT add_days('0001-01-01', 100000);
   +--------------------------------+
   | add_days('0001-01-01', 100000) |
   +--------------------------------+
   | 0274-10-17                     |
   +--------------------------------+
   

Precautions

• Ensure that the startDate parameter is in a valid date format, otherwise the function will return null.
• When the added days cause the result to exceed the date range supported by the system, the function will return null.