German date problem [message #798] |
Tue, 05 March 2002 01:52 |
Barbara
Messages: 7 Registered: November 2001
|
Junior Member |
|
|
Hi there,
I use a german Version of Oracle 8i and am confused
about inserting dates:
I created a table 'Customers' with following structure:
Name Null? Typ
----------------------------------------- -------- ----------------------------
NAME NOT NULL VARCHAR2(20)
FIRSTNAME NOT NULL VARCHAR2(20)
IDENTIFICATION NOT NULL VARCHAR2(20)
BIRTHDAY NOT NULL DATE
STREET NOT NULL VARCHAR2(30)
POSTCODE NOT NULL VARCHAR2(10)
CITY NOT NULL VARCHAR2(20)
PHONE VARCHAR2(30)
MOBILE VARCHAR2(30)
CUSTOMER_ID NOT NULL NUMBER(6)
I can add a record with following statement
insert into customers
values( 'Mustermann', 'Helmut', '2000A999', '29-nov-70', 'Wiesenstr. 23',
'70565', 'STUTTGART', '0711-6755821','0173-6566528',customer_id_seq.nextval)
/
But with the month march I can not insert a record
like
insert into customers
values( 'Mustermann', 'Helma', '2000A999', '29-mrz-70', 'Wiesenstr. 23',
'70565', 'STUTTGART', '0711-6755821','0173-6566528',customer_id_seq.nextval)
/;
an error appears
FEHLER in Zeile 2:
ORA-01858: ein nicht-numerisches Zeichen wurde gefunden, wo numerisches
erwartet wurde
Does anybody know something about this 'March Problem'
?
Thanks in advance,
Barbara
|
|
|