Return the name of the day: DAYNAME() : DAYNAME « Date Time « SQL / MySQL






Return the name of the day: DAYNAME()

     
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)

   
    
    
    
    
  








Related examples in the same category

1.Treating date-and-time as Numbers
2.DAYNAME( ) is useful in conjunction with other date-related techniques.
3.Finding the Day of the Week for a Date
4.DAYNAME( ) returns the complete day name.
5.Get the name of the day
6.DayName returns Monday, Tuesday ...
7.Use DAYNAME( ) to display weekday names instead.