KnowledgeBoat Logo

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


Related Questions