Convert date to char, and char to date with various formats
SQL>
SQL> -- Examples of the conversion functions.
SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
2 d1 DATE;
3 d2 DATE;
4 d3 DATE;
5 d4 DATE;
6 BEGIN
7 d1 := TO_DATE('1/1/02','mm/dd/yy');
8 d2 := TO_DATE('1-1-1998','mm-dd-yyyy');
9 d3 := TO_DATE('Jan 1, 2000','mon dd, yyyy');
10 d4 := TO_DATE('1/1/02','mm/dd/rr');
11 DBMS_OUTPUT.PUT_LINE('d1 = ' || TO_CHAR(d1,'dd-Mon-yyyy'));
12 DBMS_OUTPUT.PUT_LINE('d2 = ' || TO_CHAR(d2,'mm/dd/yyyy'));
13 DBMS_OUTPUT.PUT_LINE('d3 = ' || TO_CHAR(d3,'Day, Month dd, yyyy'));
14 DBMS_OUTPUT.PUT_LINE('d4 = ' || TO_CHAR(d4,'Dy, Mon dd, yyyy'));
15 END;
16 /
d1 = 01-Jan-2002
d2 = 01/01/1998
d3 = Saturday , January 01, 2000
d4 = Tue, Jan 01, 2002
PL/SQL procedure successfully completed.
SQL>
SQL>
Related examples in the same category