Date Functions – Day, DayName

/*
  Select Day Name
  Day Name
  Day Of Week
  Day Of Month
  Day Of Year
*/

SELECT CURDATE() AS Today, DAYNAME(CURDATE()) AS TodayName;

SELECT CURDATE() AS Today, DAYNAME('2016-07-30') AS TodayName;

SELECT name, date, DAYNAME(date) FROM `try`;

SELECT name, date, DAYNAME(date), DAYOFMONTH(date) FROM `try`;

SELECT name, date, DAYNAME(date), DAYOFMONTH(date), DAYOFWEEK(date) FROM `try`;

SELECT name, date, DAYNAME(date), DAYOFMONTH(date), DAYOFWEEK(date), DAYOFYEAR(date) FROM `try`;