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!

using add_months fuction

689454Jul 6 2009 — edited Jul 6 2009
Dear all,

here i have a small problem but it creating lots of problems.
example i have a query like

select add_months('27-FEB-2007',3) from dual;

it displaying after 3 months the same date like 5/27/2007 is good

but if i enter this
select add_months('28-FEB-2007',3) from dual;

it was displaying like 5/31/2007.

it giving the last day of the month but not the same date after 3 months.

-------
i have written in form to fire the data after 3 months which is having the same date .
if i enter any date except the last day month, its working fine.

but i want the same thing even if i enter the last day of month that has to display the same date.

-------

Thanks in advance,

Regards,

Venkat.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2009
Added on Jul 6 2009
13 comments
877 views