MySQL – Subtract Time Value (Intervals) From Date

MySQL DATE_SUB() function allow you to substract a time value (Intervals) from the selected date.

MySQL SUBDATE() function is the synonym of DATE_SUB() function.

The following examples will return a date after substracting 10 days from the specified date 2014-01-15.

Syntax – DATE_SUB() Function

DATE_SUB(date,INTERVAL expr unit);

Example:

mysql> SELECT DATE_SUB('2014-01-15', INTERVAL 10 DAY);

Output:

'2014-01-10'

Syntax – SUBDATE() Function

SUBDATE(date,INTERVAL expr unit), SUBDATE(expr,days);

Example-1:

mysql> SELECT SUBDATE('2014-01-15', INTERVAL 10 DAY);

Output:

'2014-01-10'

Example-2:

mysql> SELECT SUBDATE('2014-01-15', 10);

Output:

'2014-01-10'

Arguments

The following table shows the expected form of the expr argument for each unit value.