SELECT DAYNAME('2000-01-01'); : DAYNAME « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. DAYNAME
mysql>
mysql>
mysql> SELECT DAYNAME('2000-01-01');
+-----------------------+
| DAYNAME('2000-01-01') |
+-----------------------+
| Saturday              |
+-----------------------+
1 row in set (0.00 sec)








14.13.DAYNAME
14.13.1.DAYNAME(date) returns the name of the weekday for date
14.13.2.SELECT DAYNAME('2000-01-01');
14.13.3.DAYNAME('2006-05-00');
14.13.4.Get DAYNAME of employee's start date