MySQL get day of week

How to get day of week in MySQL:

WEEKDAY(date)

mysql> SELECT WEEKDAY('2008-02-03 22:23:00');
mysql> SELECT WEEKDAY('2008-02-03');

(0 = Monday, 1 = Tuesday, ... 6 = Sunday)