Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. 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>