WEEKDAY(date) returns the weekday index for date (0 = Monday, 1 = Tuesday, ... 6 = Sunday). : WEEKDAY « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. WEEKDAY
mysql>
mysql> SELECT WEEKDAY('1998-02-03 22:23:00');
+--------------------------------+
| WEEKDAY('1998-02-03 22:23:00') |
+--------------------------------+
|                              1 |
+--------------------------------+
1 row in set (0.00 sec)

mysql>








14.56.WEEKDAY
14.56.1.WEEKDAY(date) returns the weekday index for date (0 = Monday, 1 = Tuesday, ... 6 = Sunday).
14.56.2.SELECT WEEKDAY('1997-11-05');
14.56.3.WEEKDAY(date) different and returns the weekday index for the given date(0=Monday, 1=Tuesday, 2=Wednesday, and so on).