Explain the DAYNAME() SQL function using suitable examples.
2 Likes
The DAYNAME() function returns the name of weekday for date. The syntax is DAYNAME(date). For example,
DAYNAME(date)
SELECT DAYNAME('2024-05-20');
+-----------------------+ | DAYNAME('2024-05-20') | +-----------------------+ | Monday | +-----------------------+
Answered By
1 Like
Explain the TRIM() SQL function using suitable examples.
Explain the MID() SQL function using suitable examples.
Explain the POWER() SQL function using suitable examples.
What will be the output of following code ?
mysql> SELECT CONCAT(CONCAT('Inform', 'atics'), 'Practices');