SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 v_sysdate DATE := SYSDATE;
3 v_date DATE;
4 v_char VARCHAR2(20);
5 BEGIN
6
7
8
9 v_char := TO_CHAR(v_sysdate, 'DD:MM:YYYY HH24:MI:SS');
10 DBMS_OUTPUT.PUT_LINE('Display as CHARACTER DD:MM:YYYY HH24:MI:SS: '||v_char);
11
12
13 END;
14 /
Display as CHARACTER DD:MM:YYYY HH24:MI:SS: 26:10:2009 10:41:36
PL/SQL procedure successfully completed.
SQL>