WEEKDAY() function in mysql

MySQL WEEKDAY Function returns the index of the day (0 for Monday, 1 for Tuesday and ......6 for Sunday).

Syntax:

WEEKDAY(date)

Example:

select WEEKDAY('2017-03-08')

Result: