Convert char to date: TO_DATE('January 01, 2000','Month DD, YYYY') : Data Type Convert « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Data Type Convert

Convert char to date: TO_DATE('January 01, 2000','Month DD, YYYY')

SQL>
SQL> -- Datatype conversion
SQL>
SQL> DECLARE
  2     myDate DATE;
  3  BEGIN
  4     myDate := TO_DATE('January 01, 2000','Month DD, YYYY');
  5
  6     DBMS_OUTPUT.PUT_LINE(myDate);
  7  END;
  8
  9
 10
 11  /
01-JAN-00

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Convert number to char
2.Converting number to character formatted as a numeric string
3.Convert char to number
4.Converting VARCHAR2 percentage data to a decimal equivalent
5.Convert date to char, and char to date with various formats
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()