Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Calculate the months between two dates

SQL> SQL> SET SERVEROUTPUT ON SQL> DECLARE   2     v_sysdate DATE := SYSDATE;   3     v_systimestamp TIMESTAMP := SYSTIMESTAMP;   4     v_date DATE;   5     v_number NUMBER(10);   6  BEGIN   7   8     -- Calculate the months between two dates   9     v_number := MONTHS_BETWEEN('13-JUN-1973', '23-JAN-1973');  10     DBMS_OUTPUT.PUT_LINE(v_number);  11  12  END;  13  / 5 PL/SQL procedure successfully completed. SQL>