Mega Code Archive
WEEKDAY(date) different and returns the weekday index for the given date(0=Monday, 1=Tuesday, 2=Wednesday, and so on).
mysql>
mysql> SELECT DAYOFWEEK('0-2-1');
+--------------------+
| DAYOFWEEK('0-2-1') |
+--------------------+
| 3 |
+--------------------+
1 row in set (0.00 sec)
mysql>