SQL Data Types Oracle PLSQL Tutorial

SQL>  SELECT TO_DATE('April 21','MONTH DD') "Sample"  from DUAL;
Sample
---------
21-APR-07
SQL>