By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT
STR_TO_DATE('2019-04 Monday', '%X-%V %W') AS `start`,
DATE_ADD(STR_TO_DATE('2019-04 Monday', '%X-%V %W'), INTERVAL 7 DAY) AS `end`
start | end |
---|---|
2019-01-28 | 2019-02-04 |