Date Time Functions MySQL Tutorial

mysql>
mysql> SELECT WEEKDAY('1997-11-05');
+-----------------------+
| WEEKDAY('1997-11-05') |
+-----------------------+
|                     2 |
+-----------------------+
1 row in set (0.00 sec)
mysql>