THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL ADDDATE() Function

❮ MySQL Functions

Example

Add 10 days to a date and return the date:

SELECT ADDDATE("2017-06-15", INTERVAL 10 DAY);
Try it Yourself »

Definition and Usage

The ADDDATE() function adds a time/date interval to a date and then returns the date.

Syntax

ADDDATE(date, INTERVAL value addunit)

OR:

ADDDATE(date, days)

Parameter Values

Parameter Description
date Required.  The date to be modified
days Required. The number of days to add to date
value Required. The value of the time/date interval to add. Both positive and negative values are allowed
addunit Required. The type of interval to add. Can be one of the following values:
  • MICROSECOND
  • SECOND
  • MINUTE
  • HOUR
  • DAY
  • WEEK
  • MONTH
  • QUARTER
  • YEAR
  • SECOND_MICROSECOND
  • MINUTE_MICROSECOND
  • MINUTE_SECOND
  • HOUR_MICROSECOND
  • HOUR_SECOND
  • HOUR_MINUTE
  • DAY_MICROSECOND
  • DAY_SECOND
  • DAY_MINUTE
  • DAY_HOUR
  • YEAR_MONTH

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Add 15 minutes to a date and return the date:

SELECT ADDDATE("2017-06-15 09:34:21", INTERVAL 15 MINUTE);
Try it Yourself »

Example

Subtract 3 hours to a date and return the date:

SELECT ADDDATE("2017-06-15 09:34:21", INTERVAL -3 HOUR);
Try it Yourself »

Example

Subtract 2 months to a date and return the date:

SELECT ADDDATE("2017-06-15", INTERVAL -2 MONTH);
Try it Yourself »

❮ MySQL Functions