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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
