SELECT
TO_CHAR(SYSDATE,'YYYY') AS year /*년도*/
, TO_CHAR(SYSDATE,'WW') AS week_seq /*주차*/
, TO_CHAR(trunc(SYSDATE,'D'),'YYYY/MM/DD') AS start_date /*시작일*/
, TO_CHAR(trunc(SYSDATE,'D')+6,'YYYY/MM/DD') AS end_date /*종료일*/
FROM DUAL
TO_CHAR(SYSDATE,'YYYY') AS year /*년도*/
, TO_CHAR(SYSDATE,'WW') AS week_seq /*주차*/
, TO_CHAR(trunc(SYSDATE,'D'),'YYYY/MM/DD') AS start_date /*시작일*/
, TO_CHAR(trunc(SYSDATE,'D')+6,'YYYY/MM/DD') AS end_date /*종료일*/
FROM DUAL
[출처] [오라클]현재날짜의 년도/주차/시작일/종료일|작성자 능력자엄군