使用SQL获取当前周别
select to_char(sysdate,'yyyyww') from dual select to_char(to_date('20200611','yyyymmdd'),'yyyyww') from dual
https://www.jianshu.com/p/0937fb8fc5ec