configuring Oracle DATE dataype to accept ANSI SQL format

From: Neil Zanella <nzanella_at_cs.mun.ca>
Date: Sat, 30 Mar 2002 22:00:30 -0330
Message-ID: <Pine.LNX.4.44.0203302155100.19990-100000@garfield.cs.mun.ca>

Hello,

Is it possible to configure the DATE datatype to accept ANSI SQL format under Oracle 8i? The default recognized format is YYYY-MMM-DD as can be seen below:

SQL> CREATE TABLE T (d DATE);

Table created.

SQL> INSERT INTO T VALUES ('13-DEC-2001'); 1 row created.

SQL> INSERT INTO T VALUES ('2001-12-13'); INSERT INTO T VALUES ('2001-12-13')

                      *

ERROR at line 1:
ORA-01861: literal does not match format string

SQL> If anyone knows how Oracle can be configured to accept ANSI SQL date format (same as ISO 8601) then please let me know.

Thanks,

Neil Received on Sat Mar 30 2002 - 19:30:30 CST