Mega Code Archive

 
Categories / Oracle PLSQL Tutorial / SQL Data Types
 

Converting a Spelled Date to DATE Format

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