Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

TO_DATE(29-DEC-1988,dd-mon-yyyy)

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   9     start_date := TO_DATE('29-DEC-1988','dd-mon-yyyy');  10     end_date := TO_DATE ('26-DEC-1995','dd-mon-yyyy');  11  12  END;  13  / PL/SQL procedure successfully completed. SQL>