mysql get day of week
snippet in sql

mysql get day of week

user7168

DAYOFWEEK();//(1 for Sunday,2 for Monday …… 7 for Saturday )

extract weekday from date in sql

user8597

SELECT WEEKDAY(date);