Adds a specified time interval to a date.
Sample usage
DATETIME_ADD(Order Date, INTERVAL 1 WEEK)
Syntax
DATETIME_ADD(datetime_expression, INTERVAL integer part)
Parameters
datetime_expression
- a Date or a Date & Time field or expression.integer
- a whole numeric field or expression representing the number of parts to add.part
- the unit of time measurement to add. DATETIME_ADD supports the following values forpart
:MICROSECOND
: available for Date & Time fields or expressions.MILLISECOND
: available for Date & Time fields or expressions.SECOND
: available for Date & Time fields or expressions.MINUTE
: available for Date & Time fields or expressions.HOUR
: available for Date & Time fields or expressions.DAY
WEEK
: This date part begins on Sunday.ISOWEEK
: Uses ISO 8601 week boundaries. ISO weeks begin on Monday.MONTH
QUARTER
YEAR
ISOYEAR
: Uses the ISO 8601 week-numbering year boundary. The ISO year boundary is the Monday of the first week whose Thursday belongs to the corresponding Gregorian calendar year.
Return data type
Date & Time
Examples
Example formula | Output |
---|---|
DATETIME_ADD(DATETIME "2023-01-25 15:30:00", INTERVAL 10 MINUTE) |
Jan 25, 2023, 3:40:00 PM |
|
Jan 30, 2023, 12:00:00 AM |
Notes
This function is not available for compatibility mode date types.
When using MONTH
, QUARTER
, or YEAR
parts, if the resulting date is at (or near) the last day of the month, DATETIME_ADD
returns the last day of the month. This can happen when the month in the resulting date has fewer days than the month in the starting date.
For example, if Date = August 31, 2020, DATETIME_ADD(Date, INTERVAL 1 MONTH)
returns September 30, 2020.