ADD_DAYS
Description
Returns a Date or Datetime adjusted by the specified number of days, either forward (positive) or backward (negative), relative to the provided Date or Datetime.
Syntax
ADD_DAYS(date/datetime, num) -> Date/Datetime
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| date/datetime | Date/Datetime | Yes | The original Date or Datetime to adjust. |
| num | Integer | Yes | The number of months to add (positive) or subtract (negative). |
Examples
ADD_DAYS(DATE(2024, 8, 8), 4)
-- Adds 4 days to 2024-08-08.
-- Returns 2024-08-12.ADD_DAYS(NOW(), -3)
-- Subtracts 3 days from now.Tips
The return type depends on the first parameter: if it's a Date, the result is a Date; if it's a Datetime, the result is a Datetime.