Date format columns

Hi,
I want to use an american date format (mm/dd/yy) when inserting data into tables. i.e : INSERT INTO TABLE (X,Y,DATE) VALUES (9,'DDD','11/24/01').
I receive the following error : "ORA-01843: not a valid month", although I have a trigger on my db : TRIGGER TR_LOGON AFTER LOGON ON DATABASE
BEGIN
         EXECUTE IMMEDIATE('ALTER SESSION SET NLS_DATE_FORMAT=MM/DD/YY'); END; what should I do to be able using queries as described ?

thanks Received on Thu Nov 08 2001 - 03:52:03 CST