Example
SELECT SUBDATE("2017-06-15", INTERVAL 10 DAY);Definition and Usage
The SUBDATE() function subtracts a time/date interval from a date and then returns the date.
Syntax
SUBDATE(
date
, INTERVAL
value unit
)OR
SUBDATE(
date
,
days
)Parameter Values
| 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 |
- 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 |
|---|