MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT STR_TO_DATE('202301 Sunday', '%X%V %W')

STR_TO_DATE('202301 Sunday', '%X%V %W')

2023-01-01

SELECT STR_TO_DATE('202301 Sunday', '%X%V %W') - INTERVAL 1 WEEK

STR_TO_DATE('202301 Sunday', '%X%V %W') - INTERVAL 1 WEEK

2022-12-25

SELECT YEARWEEK(STR_TO_DATE('202301 Sunday', '%X%V %W') - INTERVAL 1 WEEK)

YEARWEEK(STR_TO_DATE('202301 Sunday', '%X%V %W') - INTERVAL 1 WEEK)

202252

CREATE TABLE calendar (year_week_col INTEGER);
INSERT INTO calendar VALUES (202230), (202301)
SELECT YEARWEEK(STR_TO_DATE(CONCAT(year_week_col, ' Sunday'), '%X%V %W') - INTERVAL 1 WEEK) AS result
FROM calendar;

result

202229

202252