TO_CHAR

=CHAR =

Syntax:
TO_CHAR (date column name, 'format model you specify')

Description:
Used for text and character data of fixed length, including numbers, dashes and special characters

FROM d_events

 * TO_CHAR(EVENT_DATE,'FMMONTHDD,RRRR') ||
 * May 14, 2004 ||
 * April 28, 2004 ||

FROM d_events

 * ID || TO_CHAR(EVENT_DATE,'MONTHDD,YYYY') ||
 * 100 || MAY 18, 2004 ||
 * 105 || APRIL 28, 2004 ||

<span style="font-family: 'Courier New',Courier,monospace;">FROM dual

 * <span style="font-family: 'Courier New',Courier,monospace;">TO_CHAR(SYSDATE,'DDMON,YYYYHH24:MI:SS') ||
 * <span style="font-family: 'Courier New',Courier,monospace;">04 Mar, 2009 15:46:31 ||

<span style="font-family: Georgia, serif;">Other Information:
<span style="font-family: Georgia, serif;">
 * <span style="font-family: 'Courier New', Courier, monospace;">YYYY || <span style="font-family: 'Courier New', Courier, monospace;">Full year in numbers ||
 * <span style="font-family: 'Courier New', Courier, monospace;">YEAR || <span style="font-family: 'Courier New', Courier, monospace;">Year spell out ||
 * <span style="font-family: 'Courier New', Courier, monospace;">MM || <span style="font-family: 'Courier New', Courier, monospace;">Two - digit value for month ||
 * <span style="font-family: 'Courier New', Courier, monospace;">MONTH || <span style="font-family: 'Courier New', Courier, monospace;">Full name of the month ||
 * <span style="font-family: 'Courier New', Courier, monospace;">MON || <span style="font-family: 'Courier New', Courier, monospace;">Three - letter abbreviation of the month ||
 * <span style="font-family: 'Courier New', Courier, monospace;">DY || <span style="font-family: 'Courier New', Courier, monospace;">Three - letter abbreviation of the day of the week ||
 * <span style="font-family: 'Courier New', Courier, monospace;">DAY || <span style="font-family: 'Courier New', Courier, monospace;">Full name of the day of the week ||
 * <span style="font-family: 'Courier New', Courier, monospace;">DD || <span style="font-family: 'Courier New', Courier, monospace;">Numeric day of the month ||

=<span style="font-family: Georgia,serif;"> =