Retrieve the name of the weekday for a given date.
| SELECT DAYNAME(“2017-06-15”); |
The DAYNAME() function retrieves the name of the weekday for a specified date.
| DAYNAME(date) |
|
Parameter |
Description |
|
date |
Necessary. Specify the date from which to extract the weekday name. |
|
Works in: |
From MySQL version 4.0 |
Retrieve the weekday name for a given date.
| SELECT DAYNAME(“2017-06-15 09:34:21”); |
Retrieve the weekday name for the current system date.
| SELECT DAYNAME(CURDATE()); |