Mega Code Archive

 

Categories / MySQL / Date Time

 

Finding the Day of the Week for a Date

mysql> mysql> SELECT CURDATE( ), DAYNAME(CURDATE( )); +------------+---------------------+ | CURDATE( ) | DAYNAME(CURDATE( )) | +------------+---------------------+ | 2011-10-03 | Monday              | +------------+---------------------+ 1 row in set (0.00 sec)