DATEADD
Moves the given date by a specified interval.
Syntax
DATEADD(<date>, <intervals>, <interval>)
| Parameter | Type | Description |
|---|---|---|
| date | Date | A date, or a formula that evaluates to a date value. |
| intervals | Integer | The number of intervals to shift. |
| interval | Text | One of: MINUTE, HOUR, WEEK, DAY, MONTH, QUARTER, YEAR. |
Return values
Date
Examples
DATEADD(orders.created_at, 5, HOUR)
DATEADD(orders.created_at, IF(WEEKDAY(orders.created_at) == 6, 1, 0), DAY)