Oracle PL/SQL - Date type MONTHS_BETWEEN function

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Data Type
  4. DATE data type in PL/SQL

Introduction

The MONTHS_BETWEEN function is shown here: 

v_nr:= MONTHS_BETWEEN(date1,date2);

This function returns the number of months between two dates.

If this difference is not exact, you get a floating-point number where the decimal portion represents the fraction N/31 where N is the number of remaining days.

If SYSDATE were near the beginning of February, you would get results similar to those shown here:

Demo

SQL>
SQL> declare-- from   w  w w  . j a v a2 s. c o  m
  2       v_nr number;
  3  begin
  4      v_nr:=months_between(sysdate,trunc(sysdate,'Y'));
  5      DBMS_OUTPUT.put_line(v_nr);
  6  end;
  7  /
3.65837402927120669056152927120669056153

PL/SQL procedure successfully completed.

SQL>

Related Topic