Update existing date field, add interval using MySQL and PHP

Update existing date field, add interval using MySQL and PHP

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'));