Mega Code Archive

 

Categories / MySQL / Date Time

 

Perform the week shift first

mysql> mysql> SET @target = DATE_ADD(DATE_SUB(CURDATE( ),INTERVAL 14 DAY), INTERVAL 4-DAYOFWEEK(CURDATE( )) 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) mysql>