·  PLSQL – Syntax – Variables – DATE

 

- Info:

  - DATE is used to store date and time.

 

- Procedure:

  - Create "PL/SQL Application" Test.sql.

 

    Test.sql      

    DECLARE

      born DATE;

        

    BEGIN 

      born := TO_DATE('24.12.1999 13:45:15','DD.MM.YYYY HH24:MI:SS'); 

    

      DBMS_OUTPUT.PUT_LINE ( TO_CHAR(born,'DD.MM.YYYY HH24:MI:SS') );

          

    END;