Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Use the new EXTRACT function to grab individual year and month components

SQL> SQL> DECLARE   2     start_date DATE;   3     end_date DATE;   4     service_interval INTERVAL YEAR TO MONTH;   5     years_of_service NUMBER;   6     months_of_service NUMBER;   7  BEGIN   8     years_of_service := EXTRACT(YEAR FROM service_interval);   9     months_of_service := EXTRACT(MONTH FROM service_interval);  10     DBMS_OUTPUT.PUT_LINE(years_of_service || ' years and ' || months_of_service || ' months');  11  END;  12  / PL/SQL procedure successfully completed. SQL>