Skip to Main Content
Forums

Oracle Database Discussions

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-01840 input value not long enough for date format

user507131Apr 10 2008 — edited Apr 11 2008
We are using oracle 10g. We have a table which has a field called txn_time varchar2(255). The values are in this format: '2008/04/09 08:30:45.02'

But when we tried to insert '0' into this field ,it gave us the following sql error:
ORA-01840 input value not long enough for date format

Actually this is not a date field . It is a varchar field.

Why is this happening.Can't we insert '0' into varchar field....?

Please let me know if anyone knows answer for this.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2008
Added on Apr 10 2008
#general-database-discussions
11 comments
11,798 views