YearWeek
没有按预期工作,对我来说。
SELECT YEARWEEK(date_format('2022-01-03','%Y-%m-%d'),1)-1`
The actual results : 202200
Expect the result : 202152
MySQL version: 8.0.19
SELECT YEARWEEK(DATE_SUB(STR_TO_DATE('2022-01-03','%Y-%m-%d') ,INTERVAL 7 DAY))