Date Time MySQL

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