MySQL: select date of current week's monday

Question

I'm building a weekly report using MySQL queries. First I get week number by

SELECT WEEK(CURDATE());

Then I need to display the starting date of the week (Monday for my region). How to do it with MySQL only?

Thanks!

Answer 1

For thhose who need the Monday date of the current week.

If you count Monday as the first day of the week:

SELECT STR_TO_DATE(CONCAT(YEARWEEK(NOW(), 1),'Monday'), '%x%v %W');

If you count Sunday as the first day of the week:

SELECT STR_TO_DATE(CONCAT(YEARWEEK(NOW()),'Monday'), '%X%V %W');

Answer 2

-- current week monday
 (SELECT DATE_ADD(CURDATE(), INTERVAL - WEEKDAY(CURDATE()) DAY)) 

-- current week friday  
SELECT DATE_ADD((SELECT DATE_ADD(CURDATE(), INTERVAL - WEEKDAY(CURDATE()) DAY)),INTERVAL 4 DAY);

-- next week monday 
SELECT date(curdate() - interval weekday(curdate()) day + interval 1 week);

-- next week friday 
SELECT DATE_ADD((SELECT date(curdate() - interval weekday(curdate()) day + interval 1 week)),INTERVAL 4 DAY);