MySQL:

DAYNAME

Syntax:
DAYNAME(date)

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.

Example

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

bottom of page