DATE_SUB(date,INTERVAL expr unit) : DATE_SUB « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. DATE_SUB

expr is an expression specifying the interval value.

expr is a string.

expr may start with a '-' for negative intervals.

unit is a keyword indicating the units in which the expression should be interpreted.

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

mysql>
mysql> select DATE_SUB(curdate(), INTERVAL 1 DAY);
+-------------------------------------+
| DATE_SUB(curdate(), INTERVAL 1 DAY) |
+-------------------------------------+
| 2007-07-21                          |
+-------------------------------------+
1 row in set (0.00 sec)

mysql>