mysql> select now(), date_sub(now(), INTERVAL 1 DAY), date_sub(now(), INTERVAL 1 MONTH);
+---------------------+---------------------------------+-----------------------------------+
| now() | date_sub(now(), INTERVAL 1 DAY) | date_sub(now(), INTERVAL 1 MONTH) |
+---------------------+---------------------------------+-----------------------------------+
| 2008-04-22 12:30:06 | 2008-04-21 12:30:06 | 2008-03-22 12:30:06 |
+---------------------+---------------------------------+-----------------------------------+
1 row in set (0.00 sec)
