SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01810: format code appears twice

dbajugDec 2 2010 — edited Dec 2 2010

Hi all,

I'm doing an insert statement and one of the values is a timestamp column.

I put to_timestamp('10/11/10 10:42:06,309000','dd/mm/yy HH24:MI:SS.FFFFFF') and appears the error ORA-01810

What is wrong?

Regards,
dbajug

This post has been answered by BluShadow on Dec 2 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2010

Added on Dec 2 2010

4 comments

13,362 views