SQL Language (MOSC)

MOSC Banner

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center