mysql get weekday from date code example
Example 1: mysql get day of week
DAYOFWEEK();//(1 for Sunday,2 for Monday …… 7 for Saturday )
Example 2: extract weekday from date in sql
SELECT WEEKDAY(date);
DAYOFWEEK();//(1 for Sunday,2 for Monday …… 7 for Saturday )
SELECT WEEKDAY(date);