Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generating date using add_months function

BraamDec 16 2014 — edited Dec 19 2014

Hi all,

    Am going to generate a next month using Add_months(TO_DATE('29-FEB-2012', 'DD-MON-YYYY'),1) am getting the 31-MAR-2012.

    But am expecting date is 29-MAR-2012.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2015
Added on Dec 16 2014
20 comments
5,734 views