Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. DAYOFWEEK(date) returns the weekday index for date (1 = Sunday, 2 = Monday, , 7 = Saturday)
mysql>
mysql> SELECT DAYOFWEEK('1998-02-03');
+-------------------------+
| DAYOFWEEK('1998-02-03') |
+-------------------------+
|                       3 |
+-------------------------+
1 row in set (0.00 sec)
mysql>