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-01722 invalid number in sql statement

Christian PitetFeb 18 2022 — edited Feb 18 2022

Hi,
I have a simple SQL statement and it throws an error message "ora-01722 invalid number"

select 1 from BO_KM where to_char(date1, 'fmDay fmDD fmMonth YYYY') = to_char(:P16_DATE1, 'fmDay fmDD fmMonth YYYY')

Content of the bind variable :P16_DATE1 is "Mardi 01 Février 2022".
DATE1 is column type DATE.
How to solve this ?
Best regards.
Christian

This post has been answered by Hub Tijhuis on Feb 18 2022

Jump to Answer

Added on Feb 18 2022

4 comments

639 views