Example
Return the weekday name for a date:
sql
SELECT DAYNAME("2017-06-15");
Definition and Usage
The DAYNAME() function returns the weekday name for a given date.
Syntax
text
DAYNAME(date)
Parameter Values
| Parameter | Description |
|---|---|
| date | Required. The date to extract the weekday name from |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the weekday name for a date:
sql
SELECT DAYNAME("2017-06-15 09:34:21");
Example
Return the weekday name for the current system date:
sql
SELECT DAYNAME(CURDATE());