Name

WEEKDAY( )

Synopsis

WEEKDAY(date)

This function returns the number for the day of the week. Monday is considered the first day of the week for this function and it returns a value of 0; Sunday returns 6.

SELECT WEEKDAY('2005-01-01')
       AS 'Saturday, Jan. 1';
+------------------+
| Saturday, Jan. 1 |
+------------------+
|                5 |
+------------------+

Get MySQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial