현재날짜의 년도/주차/시작일/종료일

|
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

 

And