SELECT DAYNAME('2000-01-01'); : DAYNAME « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. DAYNAME

mysql>
mysql>
mysql> SELECT DAYNAME('2000-01-01');
+-----------------------+
| DAYNAME('2000-01-01') |
+-----------------------+
| Saturday              |
+-----------------------+
1 row in set (0.00 sec)