oracle - 요일계산(2)

select  to_char(sysdate, 'd')

from dual;

select to_char(to_date(sysdate - to_char(sysdate, 'd')+2), 'mm/dd'), to_char(to_date(sysdate - to_char(sysdate, 'd')+ 6), 'mm/dd')

from dual

select to_char(to_date(sysdate - to_char(sysdate, 'd')+6), 'mm/dd'), to_char(to_date(sysdate - to_char(sysdate, 'd')+ 8), 'mm/dd')

from dual