DAYNAME()
DAYNAME(date)
date
Returns the name of the weekday for the date. This code returns the string “Saturday”:
SELECT DAYNAME('2016-02-03');