mysql get week day code example

Example: extract weekday from date in sql

SELECT WEEKDAY(date);