selectday,dayofweek(day) as dw1,date_add(day,1 - dayofweek(day))as Su_s -- 周日_start,date_add(day,7 - dayofweek(day))as Sa_e -- 周六_end,case when dayofweek(day) = 1 then 7 else dayofweek(day) - 1 end as dw2,date_add(day,1 - case when dayofweek(day) = 1 then 7 else dayofweek(day) - 1 end) as Mo_s -- 周一_start,date_add(day,7 - case when dayofweek(day) = 1 then 7 else dayofweek(day) - 1 end) as Su_e -- 周日_endfrom (select '-05-20' as day) t1
结果: