MySQL SUBDATE() 函数

从日期中减去 10 天并返回日期：

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

定义和用法

SUBDATE() 函数从日期中减去时间/日期间隔，然后返回日期。

SUBDATE( date, INTERVAL value unit)

或者：

SUBDATE( date, days)

Parameter	Description
date	Required. The original date
days	Required. The number of days to subtract from date
value	Required. The value of the time/date interval to subtract. Both positive and negative values are allowed
unit	Required. The type of interval. 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 开始