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