Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Finding Dates for Weekdays of Other Weeks
mysql>
mysql> SET @target =
    -> DATE_SUB(DATE_ADD(CURDATE( ),INTERVAL 4-DAYOFWEEK(CURDATE( )) DAY), INTERVAL 14 DAY);
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> SELECT CURDATE( ), @target, DAYNAME(@target);
+------------+------------+------------------+
| CURDATE( ) | @target    | DAYNAME(@target) |
+------------+------------+------------------+
| 2011-10-03 | 2011-09-21 | Wednesday        |
+------------+------------+------------------+
1 row in set (0.00 sec)