 <p>You can use like </p> <pre><code>CREATE OR replace PROCEDURE Test_procedure IS date CHAR(10); BEGIN SELECT To_char(SYSDATE, 'MM/DD/YYYY') INTO date FROM dual; dbms_output.Put_line(date); END; </code></pre> <p>it will return date into char format.</p> <p>If you want to get date into date format just declare the date type variable then assign the sysdate value INTO that variable.Then use DBMS_OUTPUT.PUT_LINE(variable) to print the DATE.</p>