Tag mysql date before

MySQL MONTHNAME Function

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)

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.