TO_DATE


 * TO_DATE **
 * TO_DATE('character string', 'format model') **
 * __ DESCRIPTION __**** : To convert a character string to a date format, use; **
 * __ DEFINITION: __**** Used for date and time values. Internally, Oracle stores dates as numbers and by default DATE information is displayed as **** DD-MON-YY (ex: 01-JAN-09) **
 * __FUNCTION ARGUMENT: __**** This conversion takes a nondate value character string such as "November 3, 2001" and convert the date value. **
 * __EXAMPLE: __**
 * SELECT id, TO_CHAR(event_date, 'MONTH DD, YYYY') **
 * FROM d_events; **
 * ID || TO_CHAR(EVENT_DATE, 'MonthDD, YYYY') ||
 * 100 || May14, 2004 ||
 * 105 || April28, 2004 ||


 * SELECT TO_CHAR(event_date, 'fmMonthdd, RRRR') **
 * FROM d_events; **
 * TO_CHAR(EVENT_DATE, 'fmMonthdd, YYYY') ||
 * May14, 2004 ||
 * April28, 2004 ||


 * FROM DUAL; SELECT TO_DATE('May10,1989','fxMonDD,RRRR') AS "Convert" FROM DUAL; **
 * Convert ||
 * 10-MAY-89 ||