How to use ADDDATE function in mysql

It is believed that many inexperienced people have no idea about how to use the ADDDATE function in mysql. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

ADDDATE (date,INTERVAL expr type) ADDDATE (expr,days)

When activated by the INTERVAL format of the second parameter, ADDDATE () is synonymous with DATE_ADD (). The related function SUBDATE () is synonymous with DATE_SUB (). For information on the INTERVAL parameter, see the discussion on DATE_ADD ().

> SELECT DATE_ADD ('1998-01-02, INTERVAL 31 DAY)

-> '1998-02-02'

Mysql > SELECT ADDDATE ('1998-01-02, INTERVAL 31 DAY)

-> '1998-02-02'

If the days parameter is only an integer value, MySQL 5.1 adds it to expr as a day value.

Mysql > SELECT ADDDATE ('1998-01-02, 31)

-> '1998-02-02'

After reading the above, have you mastered how to use the ADDDATE function in mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!