select to_char(t.d,'YYYY-MM-DD') as week from (
select trunc(to_date('2006-01-01','yyyy-mm-dd'), 'MM')+rownum-1 as d
from espc_mms_rpt
) t
where trim(to_char(t.d, 'Day')) = '星期五'
select trunc(to_date('2006-01-01','yyyy-mm-dd'), 'MM')+rownum-1 as d
from espc_mms_rpt
) t
where trim(to_char(t.d, 'Day')) = '星期五'