SQL Data Types Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. SQL Data Types
  4. 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>