Tutorial Gateway

MySQL ADDDATE Function

by

MySQL ADDDATE function is a Synonym of the DATE_ADD Function. This Date Function adds the specified intervals to the given date & time and returns the date or DateTime.

In this section, we show you how to use this MySQL ADDDATE function to add specified intervals to a date expression with an example.

MySQL ADDDATE Syntax

The basic syntax of the ADDDATE() Function in MySQL is as shown below:

ADDDATE(Date, INTERVAL expression Unit);
  • Date: Accepts either DateTime value or a string date
  • Expression: Specify a Value or number of Units to add.
  • Unit: It accepts unit values range from Microsecond to Year

TIP: I suggest you to refer to the Date Function article to understand the Units after the Interval.

MySQL ADDDATE function Example

The following are the list of examples that help you understand the use of this ADDDATE function.

In this example, First, we are adding 31 days to a given Datetime expression. Next, we added 16 Weeks. Within the third statement, we added 18 Months to that Date.

SELECT ADDDATE('2019-02-28 23:59:59', INTERVAL 31 DAY);

SELECT ADDDATE('2019-02-28 23:59:59', INTERVAL 16 WEEK);

SELECT ADDDATE('2019-02-28 23:59:59', INTERVAL 18 MONTH);

OUTPUT

MySQL ADDDATE Function 1

In this MySQL ADDDATE function example, we added 5 Quarters to a given Datetime expression. Next, added 4 Years. In the last statement, we added 12 Years and 8 Months to the given DateTime value.

SELECT ADDDATE('2019-02-28 23:59:59', INTERVAL 5 QUARTER);

SELECT ADDDATE('2019-02-28 23:59:59', INTERVAL 4 YEAR);

SELECT ADDDATE('2019-02-28 23:59:59', INTERVAL '12-10' YEAR_MONTH);

OUTPUT

MySQL ADDDATE Function 2