Example
Return the name of the month for a date:
SELECT MONTHNAME("2017-06-15");
Definition and Usage
The MONTHNAME() function returns the name of the month for a given date.
Syntax
MONTHNAME(date)
Tag: mysql date before
MySQL ADDDATE Function
Example
Add 10 days to a date and return the date:
SELECT ADDDATE("2017-06-15", INTERVAL 10 DAY);
Definition and Usage
The ADDDATE() function adds a time/date interval to a date and then returns the date. Continue reading MySQL ADDDATE Function