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-01801: date format is too long for internal buffer

318475Apr 27 2004 — edited Apr 27 2004

Hi,

When i select a field d_valid_mvt(date) from a table in sql*plus environement,i have this error:ORA-01801: date format is too long for internal buffer
But, when i do select to_char(d_valid_mvt,'dd/mm/yyyy'), the date is 00/00/0000.

the date d_valid_mvt is generated via a client/server application.
The version of oracle is 8.1.7.

Please help.
Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2004

Added on Apr 27 2004

#general-database-discussions

6 comments

12,659 views