DAYNAME

Return the weekday name for a date or timestamp.

Syntax

DAYNAME(date)

Example

SELECT DAYNAME('2020-06-20');

The above query returns:

Saturday