>select TO_CHAR(SAMPLE_DATE,'DD-MON-YYYY') from test;
>TO_CHAR(SAM
>-----------
>28-MAR-2001
>
>You really are doing nothing wrong oracle just shows the dates as 2 characters.

Thanks for the reply. I mainly wanted to make sure there was not something I was missing in the syntax of TO_DATE()