Date of Monday of this week

from the Artful Common Queries page


set @d = '2011-11-29';
select adddate( date(@d), interval 2-dayofweek(@d) day ) as 1stdayofweek;
+---------------+
| 1stydayofweek |
+---------------+
| 2011-11-28    |
+---------------+

Last updated 29 Nov 2011




Return to the Artful Common Queries page