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-01861 Literal does not match format string

524252Jul 20 2006 — edited Jul 20 2006

Hi ,

for following AND clause

AND TO_DATE(SUBSTR(KRD.PARAMETER10, 1, 10), 'YYYY-MM-DD') >= TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, -1), 'YYYY-MM') || '-01', 'YYYY-MM-DD')

I am getting the ORA -01861 error. with oracle version 9.2.07
While for same data with oracle 9.2.05 i am not getting this error..

It is quite apparent lieral doesnt match string is with unformatted string within to_date()
But as Data is same in both instances is there any way where I can find culprit record in column parameter10

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2006

Added on Jul 20 2006

5 comments

536 views