date_add

Description

Calculations with date and time values.

Arguments

#	Required	Description
1		A datetime device or a datetime string The datetime string must be in the format YYYY-MM-DD HH:MM:SS.
2		A number and unit. The number can be either positive or negative. The unit can be - SECOND - MINUTE - HOUR - DAY - MONTH - YEAR

Return value

The returned datetime string is always in the format %Y-%m-%d %H:%M:%S. So in case of the third example, the output will be "2016-01-01 00:00:00".

Examples

IF DATE_ADD(datetime, +1 HOUR) == ...
IF DATE_ADD(datetime, -1 DAY) == ...
IF DATE_ADD(2015-12-31, 23:59:59, +1 SECOND) == ...
IF DATE_ADD(datetime, RANDOM(-3, +3) DAY) == ...
IF DATE_FORMAT(DATE_ADD(2015-01-01 21:00:00, RANDOM(0, 120) MINUTE), \"%Y-%m-%d %H:%M:%S\", %H.%M) == ...

Changed in version 8.1.0.

IF DATE_ADD(datetime, '+1 HOUR') == ...
IF DATE_ADD(datetime, '-1 DAY') == ...
IF DATE_ADD('2015-12-31, 23:59:59', '+1 SECOND') == ...
IF DATE_ADD(datetime, RANDOM(-3, +3) . '  DAY') == ...
IF DATE_FORMAT(DATE_ADD('2015-01-01 21:00:00', RANDOM(0, 120) . ' MINUTE'), '%Y-%m-%d %H:%M:%S', %H.%M) == ...