Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. Converting spelled date to DATE format
SQL>
SQL> -- Converting spelled date to DATE format.
SQL> SELECT TO_DATE('January 15','MONTH DD') "Sample" from DUAL;
Sample
---------
15-JAN-06
SQL>