MySQL DAYNAME() function

DAYNAME() function

MySQL DAYNAME() returns the name of the week day of a date specified in the argument.

This function is useful in -

  • DAYNAME() is used to group, analyze, and visualize data based on the day of the week.
  • It helps in identifying patterns, trends, or variations that occur on specific days.
  • In applications that involve scheduling events, DAYNAME() helps identify the day of the week on which an event is scheduled, aiding in planning and coordination.
  • When plotting data on graphs or charts, DAYNAME() can be used to label the x-axis with the names of the days, making the chart more informative.
  • For reservation systems, DAYNAME() helps display the day of the week when customers make reservations, facilitating booking decisions.
  • DAYNAME() can be used to analyze business operations that vary by day, such as customer footfall, sales, or website traffic.



Where date1 is a date.

Syntax Diagram:

MySQL DAYNAME() Function - Syntax Diagram

MySQL Version: 8.0

Pictorial Presentation:

Pictorial Presentation of MySQL DAYNAME() function

Example: MySQL DAYNAME() function

The following statement will return the name of the week day of the specified date 2008-05-15.


SELECT DAYNAME('2008-05-15');


mysql> SELECT DAYNAME('2008-05-15');
| DAYNAME('2008-05-15') |
| Thursday              | 
1 row in set (0.01 sec)

Video Presentation:

All Date and Time Functions :

Click here to see the MySQL Date and time functions.


Follow us on Facebook and Twitter for latest update.

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook