using add_months fuction
689454Jul 6 2009 — edited Jul 6 2009Dear 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.