OraFAQ Forum: Server Administration » ORA-01810: format code appears twice.

Home » RDBMS Server » Server Administration » ORA-01810: format code appears twice.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01810: format code appears twice. [message #57788]

Tue, 08 July 2003 04:31

Devashish Rughwani
Messages: 6
Registered: November 2002

Junior Member

I am trying to update a date column with

String DateStr ="to_date('"+dtSql.toString() +"',";
DateStr = DateStr+ "'YYYY-MM-DD HH24:MI:SS.mmm'"") ";

dtSql is a java.sql.Timestamp object.

I want to store the millisecond information also in the column to be updated.

But I get "ORA-01810: format code appears twice."

Could any help on the date format to use for storing milliseconds in Oracle.

Regards,
Devashish

Report message to a moderator

Re: ORA-01810: format code appears twice. [message #57789 is a reply to message #57788]

Tue, 08 July 2003 04:49

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Oracle only stores up to seconds in DATES. Milliseconds can be stored in the TIMESTAMP datatype (available in Oracle 9i). You can workaround this by using a Java Stored Procedure and store the value in a VARCHAR2. Sad but true....

MHE

Report message to a moderator

Previous Topic:	I can't restore controlfile with set until
Next Topic:	I/O contention

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 06 00:43:17 CDT 2025