MySQL Quick Tip: Using the DAYOFWEEK Function

Knowing the day of the week for a given date is a common requirement for programs and database administrators who want to obtain data from a database. Fortunately, MySQL has a function known as WEEKDAY this makes collecting this information easy.

The order of the days starts with Sunday (1), Monday (2), Tuesday (3), Wednesday (4), Thursday (5), Friday (6) and ends on Saturday (7).

You can use the … CHOOSE Command with the WEEKDAY Function to query the MySQL database to find out which day of the week a certain date falls. For example, here is a sample MySQL query with WEEKDAY:

SELECT WEEKDAY (‘2021-03-11’);

Running this query would result in the output:


November 3, 2021 falls on a Thursday, which is the 5th day of the week.

Read: MySQL INSERT or REPLACE commands

Related posts

Axosoft Scrum Project Management Tool Review


Top Online Courses to Learn R Programming


Product Update: Ad Revenue from HyperBid now available on GameAnalytics


Leave a Comment