The examples were created with the MyWAY SQL manager: Download
How to use the DAYNAME() function in MySQL and MariaDB databases
In MySQL and MariaDB the DAYNAME() function is used to get the name of the day of the week for a given "Date" or "Date and Time" expression. The function returns the name of the weekday as a string value and as a parameters, table column names or other expressions can also be used to retrieve the day name for specific dates in SQL queries on databases, which can be used in various reporting or data analysis applications. The dayname is based on the language and locale settings of the MySQL or MariaDB server.