Loading lesson path
Concept visual
Start at both ends
Return the weekday index for a date:
SELECT DAYOFWEEK("2017-06-15");The DAYOFWEEK() function returns the weekday index for a given date (a number from 1 to 7).
Formula
1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday,
5 = Thursday, 6 = Friday, 7 = Saturday.date )
Required. The date to return the weekday index fromFrom MySQL 4.0
Return the weekday index for a date: SELECT DAYOFWEEK("2017-06-15 09:34:21");
Return the weekday index for the current system date:
SELECT DAYOFWEEK(CURDATE());❮ MySQL Functions