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-01830: date format Issue

2806064Apr 1 2015 — edited Apr 2 2015

We are using new ATM system since 5 months. Yesterday evening we have found this error in main ATM module.

ORA-01830: date format picture ends before converting entire input string

"TO_CHAR(SYSTIMESTAMP, 'DD-MON-YYYY HH:MI:SS.FF AM') " is the sql function generate this error.

But my question is how this statement worked throughout this period?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2015

Added on Apr 1 2015

#general-database-discussions

15 comments

5,053 views