Home » Non-English Forums » German » German date problem
German date problem [message #798] Tue, 05 March 2002 01:52 Go to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: owa_util.ident_arr
Next Topic: special chars and german "umlaute"
Goto Forum:
  


Current Time: Sat Jan 18 20:10:37 CST 2020