Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. 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)