Mega Code Archive

 

Categories / MySQL / Date Time

 

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)