DAYOFWEEK « Date Time Functions « MySQL Tutorial






14.15.DAYOFWEEK
14.15.1.DAYOFWEEK(date) returns the day of the week for a given date, starting with 1=Sunday, 2=Monday, 3=Tuesday, and so on.
14.15.2.DAYOFWEEK(date) returns the weekday index for date (1 = Sunday, 2 = Monday, ..., 7 = Saturday).