MONTHS_BETWEEN : Date Functions « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. Date Functions

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>








21.10.Date Functions
21.10.1.Working with dates and built-in functions EXTRACT
21.10.2.TRUNC and ROUND
21.10.3.ROUND
21.10.4.ADD_MONTHS
21.10.5.LAST_DAY
21.10.6.MONTHS_BETWEEN
21.10.7.Use TRUNC to get only the time
21.10.8.Returning a point just before a specific midnight with TRUNC
21.10.9.TO_DATE('29-DEC-1988','dd-mon-yyyy')