Home » Non-English Forums » German » German date problem
German date problem [message #798] Tue, 05 March 2002 01:52 Go to next 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
Re: German date problem [message #799 is a reply to message #798] Tue, 05 March 2002 02:11 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
first of all , i do not german.sorry if i am messing u up.

it seems ur date format is DD-mon-yyyy.

so use like this
1.FIRST METHOD:

insert into customers
values( 'Mustermann', 'Helma', '2000A999', TO_DATE('29-mrz-70','DD-MON-YY'), 'Wiesenstr. 23',
'70565', 'STUTTGART', '0711-6755821','0173-6566528',customer_id_seq.nextval);

change the date format accodingly

make sure nls_language has been properly set

2.SECOND METHOD:

set NLS_DATE_FORMAT .....

and use the same insert staement as before

------------------
ORA-01858 a non-numeric character found where a digit was expected

Cause:

The input data to be converted using a date format model was incorrect. The format model expected a number but found a non-numeric character.
Action:

Check the input data and the date format model to make sure the elements match in number and type, then retry the operation.

----------------------------
Re: German date problem [message #8728 is a reply to message #798] Mon, 22 September 2003 03:25 Go to previous messageGo to next message
Wolfgang Walgenbach
Messages: 1
Registered: September 2003
Junior Member
Please try: ... ,'29-MÄR-70', ..
Re: German date problem [message #161931 is a reply to message #8728] Tue, 07 March 2006 23:23 Go to previous message
sathya103
Messages: 1
Registered: March 2006
Junior Member
Try the following.

alter system set nls_language="german din"

Then, following will be output.

SQL> select sysdate from dual;

SYSDATE
---------
07-MRZ-06


Best regards,
Sathya.
Previous Topic: owa_util.ident_arr
Next Topic: special chars and german "umlaute"
Goto Forum:
  


Current Time: Thu Mar 28 11:41:27 CDT 2024