DAYNAME(date)

MySQL 8.4

Returns the name of the weekday for date. The language used for the name is controlled by the value of the lc_time_names system variable (see Section 12.16, “MySQL Server Locale Support”). Returns NULL if date is NULL.

Syntax

MYSQL

SELECT DAYNAME('2007-02-03');
'Saturday'

Examples

Example

MYSQL

SELECT DAYNAME('2007-02-03');
'Saturday'