CBSE Class 12 Informatics Practices Question 5 of 24

MySQL Functions — Question 5

Back to all questions
5
Question

Question 2(iv)

Explain the DAYNAME() SQL function using suitable examples.

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                |
+-----------------------+
Get the Bright Tutorials app Stuck on a question? Ask Bright Buddy — your AI tutor — for step-by-step help in the app.