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')) = '星期五'
版权声明：本文为sunshinegeorge原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。