Informatics Practices
Explain the DAYNAME() SQL function using suitable examples.
SQL Queries
3 Likes
Answer
The DAYNAME() function returns the name of weekday for date. The syntax is DAYNAME(date)
. For example,
SELECT DAYNAME('2024-05-20');
Output
+-----------------------+
| DAYNAME('2024-05-20') |
+-----------------------+
| Monday |
+-----------------------+
Answered By
3 Likes