#1305 – FUNCTION clubmc.DATEADD does not exist (Mysql) [ Solved ]

i want to select all the date + 2 month from my table, i write this query

select DATEADD(month, 2, `creatdate_time`) AS DateAdd FROM app_user

but the console shows me this errors:

#1305 - FUNCTION clubmc.DATEADD does not exist

SOLVED

select  DATE_ADD(`creatdate_time`, INTERVAL +2 MONTH) FROM app_user

Solution

Your syntax is wrong.

select date_add(`creatdate_time`, INTERVAL 2 MONTH) AS DateAdd FROM app_user

Documentation Date add