简单日期问题，20分足够了

Question

select to_char(add_months(sysdate,1),'yyyymm')||'01'  from dual --->20051001

Answer 1

select trunc(add_months(sysdate,1),'MM') from dual

Answer 2

select last_day(sysdate)+1 from dual

Answer 3

SQL> select last_day(sysdate)+1 from dual;LAST_DAY(S
----------
2005-10-01SQL> select last_day('2005-5-2')+1 from dual;LAST_DAY('
----------
2005-06-01SQL> select last_day('2005-12-4') from dual;LAST_DAY('
----------
2005-12-31SQL>