mysql> select curdate(), curdate() + interval 1 month;
+------------+------------------------------+
| curdate()  | curdate() + interval 1 month |
+------------+------------------------------+
| 2007-05-31 | 2007-06-30                   |
+------------+------------------------------+
1 row in set (0.00 sec)