UPDATE tbl_name SET end_date = end_date + INTERVAL 18 DAY INTERVAL 1 MONTH 

We can add Hour, Minute, Second, Week etc. In query DAY, MONTH will work, not DAYS or MONTHS.

In php:

$date = "2010-09-17";
echo date('Y-m-d H:i:s', strtotime($date. '1 days 2 months 2 years 7 hours 20 minutes 53 seconds'));

Advertisements