Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Return the day of the week by number
mysql>
mysql>
mysql> SELECT DAYOFWEEK('2004-12-31 23:59:59');
+----------------------------------+
| DAYOFWEEK('2004-12-31 23:59:59') |
+----------------------------------+
|                                6 |
+----------------------------------+
1 row in set (0.00 sec)