Month Between Oracle. Get the number of months between february 10 2012 and january 01 2012. In other cases the months between function will calculate the fractional portion of the result based.
The minuend date is a date which is subtracted from. Let s take some. Sql select months between 2 to date 02 02 2015 mm dd yyyy 3 to date 12 01 2014 mm dd yyyy months 4 from dual.
Select months between to date 02 02 1995 mm dd yyyy to date 01 01 1995 mm dd yyyy months from dual.
In oracle months between date1 date2 function returns the number of months between two dates as a decimal number. Otherwise oracle database calculates the fractional portion of the result based on a 31 day month and considers the difference in time components date1 and date2. The first date used to calculate the number of months between. Sql select months between 2 to date 02 02 2015 mm dd yyyy 3 to date 12 01 2014 mm dd yyyy months 4 from dual.
