mysql> SELECT CURDATE() as sekarang, DATE_ADD(CURDATE(), INTERVAL 1 WEEK) as '+ 1 minggu', -> DATE_SUB(CURDATE(), INTERVAL 10 DAY) as '- 10 hari'; +------------+------------+------------+ | sekarang | + 1 minggu | - 10 hari | +------------+------------+------------+ | 2010-09-20 | 2010-09-27 | 2010-09-10 | +------------+------------+------------+ 1 row in set (0.00 sec)