>>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.

No problems, Oracle dates can be a pain.

INSERT INTO table_name (date_field) VALUES (TO_DATE('02/20/2001','MM/DD/YYYY'));

HTH

Les