Home » Infrastructure » Windows » Seeking help on the Date format
Seeking help on the Date format [message #100318] Fri, 11 October 2002 02:30 Go to next message
Cran
Messages: 2
Registered: October 2002
Junior Member
Hi,all
I'm currently using Oracle8i Personal Edition on my Simplified Chinese Windows 2000 Professional.But I've met a big problem on inserting data with type Date.
When I tried the insert data through the DBA GUI,I entered "18-Apr-2002" into a field with type Date but I got an Error message "ORA-01843:not a valid month".But the sql query generated could be executed successfully in the SQLplus Worksheet!!After inserting the data,I found the month of that field was displayed in Chinese in DBA GUI!!!What's wrong with this??Besides that,the same sql query didn't work when it's executed in a Java program,same error message showed,ie. ORA-01843 blah blah.
Can anyone help me solve this problem?
Thanks a lot!!

Report message to a moderator

Re: Seeking help on the Date format [message #100319 is a reply to message #100318] Fri, 11 October 2002 02:34 Go to previous messageGo to next message
Cran
Messages: 2
Registered: October 2002
Junior Member
PS.I'm quite sure I chose the product language to be English during installation.

Report message to a moderator

Re: Seeking help on the Date format [message #100341 is a reply to message #100318] Thu, 24 October 2002 05:13 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
force using TO_DATE('DATE','DATE_FORMAT')

ex TO_DATE('24/10/2002','DD/MM/RRRR')

Report message to a moderator

Previous Topic: Re: Installing Developer 2000 and Oracle 7 on Windows 98
Next Topic: Re: ODBC Drvier for Oracle 8.1.6.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 06:16:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.