Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

SELECT TO_CHAR(TO_DATE(05-FEB-1968), MONTH DD, YYYY)

SQL>  SELECT TO_CHAR(TO_DATE('05-FEB-1968'), 'MONTH DD, YYYY')   2  FROM dual; TO_CHAR(TO_DATE('0 ------------------ FEBRUARY  05, 1968 SQL>