Date in Oracle 8i

[shyamal]

The following insert generates this error:

INSERT INTO DEV.SLEONTPS (NVARCHAR,FLDDATE1) VALUES ('THIS','01/01/2001');

Error:
INSERT INTO DEV.SLEONTPS (NVARCHAR,FLDDATE1) VALUES ('THIS','01-01-2001')
*
ERROR at line 1:
ORA-01843: not a valid month

How are dates entered in an insert statement I thought I was using the standard date format, my datatype for the column is date.

Thanks in advance.

 

[JHoarty]

INSERT INTO DEV.SLEONTPS (NVARCHAR,FLDDATE1)
VALUES ('THIS', TO_DATE('01/01/2001', 'MM-DD-YYYY'));

John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[JHoarty]

Oops, shoulda been:

INSERT INTO DEV.SLEONTPS (NVARCHAR,FLDDATE1)
VALUES ('THIS', TO_DATE('01-01-2001', 'MM-DD-YYYY'));

I had dashes, you had slashes


John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[carp]

Or
INSERT INTO DEV.SLEONTPS (NVARCHAR,FLDDATE1)
VALUES ('THIS', TO_DATE('01/01/2001', 'MM/DD/YYYY'));
if you want to use slashes.