WEEKDAY()
WEEKDAY(date)
date
Returns the weekday index for date, where 0=Monday through 6=Sunday. This code returns the value 1:
0
6
1
SELECT WEEKDAY('2016-04-04');