The examples were created with the MyWAY SQL manager: Download
How to use the MONTHNAME() function in MySQL and MariaDB databases
In MySQL and MariaDB the MONTHNAME() function returns the name of the month for a given "Date" or "Date and Time" expression as a string value. Column names of tables or other expressions can also be used as parameters to be able to display or work with the month name as a string for SQL queries in databases, which can be useful in various reporting or data analysis scenarios. The month name is based on the language and locale settings of the MySQL or MariaDB server.
Further MySQL und MariaDB SQL Date and Time functions