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>