ITPub博客

SQL> select last_day(add_months(to_date('2007-01','yyyy-mm'),(rownum-1))) 月末日期 from dual Connect By rownum<=12;月末日期-----------2007-1-312007-2-282007-3-312007-4-302007-5-312007-6-302007-7-312007-8-312007-9-302007-10-312007-11-302007-12-31请参看http://www.itpub.net/713158.html[@more@]