WEEKDAY(): weekday number from 0 to 6 mysql function

WEEKDAY(date)

SELECT WEEKDAY('2016-09-21')

• Video Tutorial on Date function WEEKDAY()

Using CURDATE()

SELECT WEEKDAY(CURDATE())

CURDATE()

SELECT WEEKDAY('2015-02-31')

Yesterday today and tomorrow WEEKDAY()

SELECT WEEKDAY(CURDATE()- INTERVAL 1 DAY) as yesterday,
WEEKDAY(CURDATE()) as today,
WEEKDAY(CURDATE()+ INTERVAL 1 DAY) as tomorrow;