–( IW 是年的自然周; WW是年的第一天起开始算7天为一周)
–周一
select trunc(to_date('20210831','yyyymmdd'), 'iw' ) from dual;
–周日
select trunc(to_date('20210831','yyyymmdd'), 'iw' )+6 from dual;
– 上周一
select trunc(to_date('20210831','yyyymmdd'), 'iw' )-7 from dual;
– 上周天
select trunc(to_date('20220101','yyyymmdd'), 'iw' )-1 from dual;
—第几周
select to_char(TO_DATE('20210104', 'YYYYMMDD'), 'iw') as week from dual;