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!

SQL query error - Literal does not match format string

ORA_AJMay 11 2009 — edited May 11 2009

Hi All,

When I am removing these code form query then it is running fine else it is giving error of "Literal does not match format string."

AND trunc((SYSDATE)) > DECODE(fifs.id_flex_structure_name, 'XXX Service Agreement', trunc(TO_DATE
(pac.segment3, 'YYYY/MM/DD HH24:MI:SS')),trunc(SYSDATE) )

Regards,
Ajay

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2009

Added on May 11 2009

25 comments

1,784 views