Date Time Functions MySQL Tutorial

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