MySQL DAYNAME() Function
Definition and Usage
The DAYNAME() function returns the weekday name for a given date.
Syntax
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:
SELECT DAYNAME("2017-06-15 09:34:21");
Try it Yourself »
Example
Return the weekday name for the current system date:
SELECT DAYNAME(CURDATE());
Try it Yourself »