>I'm relaying a message here so if it appears that I've never used Oracle... yeah.

Ok, this guy has a date field. And teh Oracle date format is 20/Feb/2001 from the sound of it. He wants to insert in a literal thats in the form of 02/20/201. How would you do that? Thanks in advance for such a lamer question.