mysql>
mysql> SELECT DATE_SUB(CURDATE(), INTERVAL 6 MONTH);
+---------------------------------------+
| DATE_SUB(CURDATE(), INTERVAL 6 MONTH) |
+---------------------------------------+
| 2007-01-21 |
+---------------------------------------+
1 row in set (0.00 sec)
mysql>