Eric For Study

原创 罗列整一年的日期

<br />select to_char(everyday,'yyyy-mm-dd')  from (<br />select to_date('20100101','yyyymmdd') + level - 1 as everyDay from dual<br />connect by level <= <br />(last_day(to_date('20101231','yyyymmdd')) - to_date('20100101','yyyymmdd') +1));