获取每个月最后一天sql

select last_day(add_months(to_date('2006-01','yyyy-mm'),(rownum-1))) from dual Connect By rownum<=180;