mysql - How to add multiple intervals to Date_Add -

mysql - How to add multiple intervals to Date_Add -

i want add together 2 months , 2 years current date reason cannot work.

select date_add(now(), interval 2 month, interval 2 year);

try using date_add() twice:

select date_add(date_add(now(), interval 2 month), interval 2 year);

or once:

select date_add(now(), interval 14 month);

mysql date intervals