MySQL in a Nutshell

Name

DAYOFWEEK( )

Synopsis

DAYOFWEEK(date)

This function returns numerical day of the week for a given date. Sunday returns a value of 1, and Saturday returns a value of 7.

SELECT DAYOFWEEK('2005-03-01')
          AS 'Day of Week',
       DAYNAME('2005-03-01')
          AS 'Name of Day';
+-------------+-------------+
| Day of Week | Name of Day |
+-------------+-------------+
|           3 | Tuesday     |
+-------------+-------------+

In this example, the date is on the third day of the week, which is a Tuesday.