Regarding number of months

veera24 · Post by **veera24** » Wed Jun 04, 2008 9:59 pm

hi all,
Am having two i/p columns which consists of date field. Am in need to take the difference between these two columns and i got to change into number of months. Is there any function to implement the same? Or shall i take the difference between the two by using iconv function and then divide it by 30?

Your time will be highly appreciated.

Thanks in advance
veera...

ray.wurlod · Post by **ray.wurlod** » Wed Jun 04, 2008 10:27 pm

The second approach would not be accurate. On the other hand, there's nothing out of the box that satisfies the requirement. Therefore I recommend that you create a routine that decomposes the dates into year, month and day components and performs the correct arithmetic.

That way you can satisfy your business rule about the result - do you need completed months, a figure rounded to the nearest number of months, fractional months are permitted...

Take some time to design test data for the routine. For each pair of dates determine the expected result and compare this against actual.