Skip to main content

DAYNAME

Description​

Calculates the name of the day corresponding to the given date expression.

Syntax​

DAYNAME(<dt>)

Parameters​

ParameterDescription
<dt>The date expression to be calculated

Return Value​

Returns the name of the day corresponding to the given date expression.

Examples​

select dayname('2007-02-03 00:00:00');
+--------------------------------+
| dayname('2007-02-03 00:00:00') |
+--------------------------------+
| Saturday |
+--------------------------------+