Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

MONTHS_BETWEEN

The MONTHS_BETWEEN function is shown here: v_nr:= MONTHS_BETWEEN(date1,date2); The MONTHS_BETWEEN function returns the number of months between two dates. If this difference is not exact, you get a floating-point number. The decimal portion represents the fraction N/31 where N is the number of remaining days. SQL> declare   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  / 5.28567988351254480286738351254480286738 PL/SQL procedure successfully completed. SQL>