×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Understanding the DAYOFWEEK Function in MySQL
 

Submitted by: M S Sridhar(sridhar.ms@gmail.com)

Friday Jun 8th 2018 by M S Sridhar

Language: SQL, Expertise: Intermediate - Learn an easy way to figure out the day of the week for a given date.

You can easily find the day of the week for a given date in MySQL. The day starts with 1 (Sunday), 2 (Monday) and so on.

Command:

SELECT DAYOFWEEK('2018-02-20');

Expected output:

+-------------+
|DAY OF WEEK  |
+-------------+
|          3  |
+-------------+
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved