I want total months between two date (I/p)
i want exactly four batch on the basis of date , for ex.
i/p Start date : 01-JUN-2005 (or format can be 20050601 - YYYYMMDD)
i/p End Date : 01-OCT-2006 or format can be 20061001 - YYYYMMDD)
so in this scenario each batch should be 4 months (as there are 16 months in between this two dates)
so if anyone having function that return me the total number of months between two dates so that i can divide it and add in to my start date
for ex. total months / 4 i.e. 16/4
01-JUN-2005 + 4 = 01-OCT-2005
01-OCT-2005 + 4 = 01-FEB-2006
01-FEB-2005 + 4 = 01-JUN-2006
01-JUN-2006 + 4 = 01-OCT-2006
even if its possible then please provide function that having addition of month to date