Syntax:
DAYNAME(date)

Returns the name of the weekday for date. The language used for the
name is controlled by the value of the lc_time_names system variable
(https://mariadb.com/kb/en/server-system-variables#lc_time_names).

URL: https://mariadb.com/kb/en/dayname/

