months_between discrepancies between documentation and functionallity
Hello,
I've consulted the documentation on https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions089.htm and
regarding the months_between function and both states that it will return a round number if the days of the two dates are equal, if both dates are the last days of the month or if the difference in days between two dates is 31 ( If date1
and date2
are either the same days of the month or both last days of months, then the result is always an integer. Otherwise Oracle Database calculates the fractional portion of the result based on a 31-day month and considers the difference in time components