Convert date to char, and char to date with various formats : Data Type Convert « PL SQL « Oracle PL / SQL






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

1.Convert char to date: TO_DATE('January 01, 2000','Month DD, YYYY')
2.Convert number to char
3.Converting number to character formatted as a numeric string
4.Convert char to number
5.Converting VARCHAR2 percentage data to a decimal equivalent
6.Convert char to number and number to char with various formats
7.Data implicit conversion examples: from char to number
8.Data implicit conversion examples: from char to date
9.Expressing your work in scientific notation with TO_CHAR()