Loading lesson path
Concept visual
Start at both ends
Return the weekday number for a date:
SELECT WEEKDAY("2017-06-15");The WEEKDAY() function returns the weekday number for a given date.
Formula
0 = Monday, 1 = Tuesday, 2 = Wednesday, 3 = Thursday,
4 = Friday, 5 = Saturday, 6 = Sunday.date )
Required. The date or datetime to extract the weekday number from
From MySQL 4.0
Return the weekday number for a date:
SELECT WEEKDAY("2017-01-01");Return the weekday number for the current system date:
SELECT WEEKDAY(CURDATE());❮ MySQL Functions