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!

ADD_MONTHS

OrlandoDiasNov 10 2009 — edited Nov 10 2009

I have the command bellow:

select add_months(to_date('30112009','ddmmyyyy'),1) from dual

The result is 31-dec-2009. I think it is wrong. I was expecting 30-dec-2009.

Am I right?

OD

This post has been answered by 584412 on Nov 10 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2009

Added on Nov 10 2009

5 comments

317 views