{"id":6281,"date":"2017-07-13T00:38:39","date_gmt":"2017-07-13T07:38:39","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=6281"},"modified":"2023-10-15T04:37:03","modified_gmt":"2023-10-15T11:37:03","slug":"mysql-dayofweek-function","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-dayofweek-function\/","title":{"rendered":"MySQL DAYOFWEEK() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL DAYOFWEEK()<\/code> function to get the weekday index of a date.<\/p>\n\n\n\n

Introduction to MySQL DAYOFWEEK() function<\/h2>\n\n\n\n

The DAYOFWEEK()<\/code> function allows you to get a weekday index of a date <\/a>i.e., 1 for Sunday, 2 for Monday, … 7 for Saturday.<\/p>\n\n\n\n

Here’s the syntax of the DAYOFWEEK()<\/code> function:<\/p>\n\n\n

DAYOFWEEK(date)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Note that DAYOFWEEK()<\/code> function returns an index value based on the ODBC standard where weekdays are indexed with values, with 1 representing Sunday, 2 representing Monday, and so on.<\/p>\n\n\n\n
If the date is NULL<\/code>, zero ( 0000-00-00<\/code>), or invalid, the DAYOFWEEK<\/code> function returns NULL<\/code><\/a>.<\/p>\n\n\n\n
MySQL DAYOFWEEK() function examples<\/h2>\n\n\n\n
Let’s take some examples of using the DAYOFWEEK()<\/code> function.<\/p>\n\n\n\n
1) Simple DAYOFWEEK function example<\/h3>\n\n\n\n
The following example uses the DAYOFWEEK()<\/code> function to return the weekday index of December 1st, 2012<\/code>:<\/p>\n\n\n
SELECT \n  DAYNAME('2012-12-01'<\/span>), \n  DAYOFWEEK('2012-12-01'<\/span>);<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+-----------------------+-------------------------+\r\n| DAYNAME('2012-12-01'<\/span>) | DAYOFWEEK('2012-12-01'<\/span>) |\r\n+-----------------------+-------------------------+\r\n| Saturday              |                       7<\/span> |\r\n+-----------------------+-------------------------+\r\n1<\/span> row in<\/span> set<\/span> (0.02 sec)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
2) Using the MySQL DAYOFWEEK() function with table data<\/h3>\n\n\n\n
We’ll use the orders<\/code> table from the sample database<\/a> for the demonstration:<\/p>\n\n\n\n
\"The<\/figure>\n\n\n\n
The following example uses the DAYOFWEEK()<\/code> function to get the weekday index of the values in the orderDate<\/code> column:<\/p>\n\n\n
SELECT<\/span> \n  orderNumber, \n  orderDate, \n  DAYOFWEEK<\/span>(orderDate) \nFROM<\/span> \n  orders;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+-------------+------------+----------------------+\r\n| orderNumber | orderDate  | DAYOFWEEK(orderDate) |\r\n+-------------+------------+----------------------+\r\n|       10100 | 2003-01-06 |                    2 |\r\n|       10101 | 2003-01-09 |                    5 |\r\n|       10102 | 2003-01-10 |                    6 |\r\n|       10103 | 2003-01-29 |                    4 |\n...<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the DAYOFWEEK()<\/code> function to get the weekday index of a date.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t
In this query, the DAYNAME<\/a><\/code> function returns the weekday’s name while\u00a0DAYOFWEEK<\/code>\u00a0function returns the weekday index of December 1st, 2012<\/code>.<\/p>\n\n\n\n
The DAYOFWEEK<\/code> function accepts a DATE<\/a><\/code> or DATETIME<\/code><\/a> value. It returns an integer that ranges from 1 to 7 that represents Sunday to Saturday.<\/p>\n\n\n\n