包括15日:SELECT to_date('2012-'||substr('0'||to_char(rownum),-2,2)||'-15','yyyy-mm-dd')+ 6-mod(to_char(to_date('2012-'||substr('0'||to_char(rownum),-2,2)||'-15','yyyy-mm-dd'),'D'),7) 每月15日后星期五 FROM DUAL CONNECT BY rownum<=12;