DAYNAME('2006-05-00'); : DAYNAME « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. DAYNAME
mysql>
mysql> SELECT DAYNAME('2006-05-00');
+-----------------------+
| DAYNAME('2006-05-00') |
+-----------------------+
| NULL                  |
+-----------------------+
1 row in set, 1 warning (0.00 sec)

mysql>








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