Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

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>