Mysql DAYNAME
From w3cyberlearnings
Contents |
MySQL DAYNAME Function
This function returns the day name of a week. ie. Monday, Tuesday, Wednesday,...
Syntax DAYNAME
- expre: Day or datetime expression
DAYNAME(expre);
Example 1
mysql> SELECT DAYNAME('2012-05-21');
+-----------------------+
| DAYNAME('2012-05-21') |
+-----------------------+
| Monday |
+-----------------------+
1 row in set (0.00 sec)
Example 2
mysql> SELECT DAYNAME('2012-05-21 11:33:44');
+--------------------------------+
| DAYNAME('2012-05-21 11:33:44') |
+--------------------------------+
| Monday |
+--------------------------------+
1 row in set (0.00 sec)
