MySQL ADDDATE() 函数

向日期添加 10 天并返回日期：

SELECT ADDDATE("2017-06-15", INTERVAL 10 DAY);

定义和用法

ADDDATE() 函数将时间/日期间隔添加到日期，然后返回日期。

ADDDATE( date, INTERVAL value addunit)

或者：

ADDDATE( date, days)

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

工作于：	从 MySQL 4.0 开始