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!

How to get next months date

468890Nov 29 2005 — edited Nov 29 2005

Hi. How do i return date records of next month?

I am aware i may need sysdate.

At the moment i have been trying:

WHERE delivery_date = ADDMONTHS (sysdate, 1);

No avail.

Ideas?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2005

Added on Nov 29 2005

1 comment

5,842 views