Re: Datatype conversion help

On Tuesday 08 Jul 2003 10:19 pm, Yasir Malik wrote:
> Yes, Mr. Nachbaur helped me out.  Thanks.  I don't think I can do
> to_char(<whatever date>, 'MM-DD-YYYY)
> because the date fields are originally stored as separate integers in my
> schema (they have to be that way).  I still can't understand why the extra
> space was added after the dash.  It just made my life more miserable.
> Yasir

You are not the only one it makes miserable. I believe it's there to provide
compatibility with Oracle/some other db. Their function does it so ours
should too. Very strange behaviour though.

--  Richard Huxton