Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. WEEKDAY(date) returns the weekday index for date (0 = Monday, 1 = Tuesday, 6 = Sunday)
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>