MySQL Manual | 6.3.4 Date and Time Functions

mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2003-07-02 22:24:43 |
+---------------------+
1 row in set (0.00 sec)


mysql> SELECT NOW() + INTERVAL 1 MONTH;
+--------------------------+
| NOW() + INTERVAL 1 MONTH |
+--------------------------+
| 2003-08-02 22:25:21      |
+--------------------------+
1 row in set (0.00 sec)
[download]

I'll leave the rest up to you...