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!

To_char not working as expected

Abhijit2610Oct 11 2019 — edited Oct 11 2019

Hello,

I have below function from which :Effective date is variable if I put colon for the same then it is not reading the variable and if I remove the colon then giving the error ORA-01858: a non-numeric character was found where a numeric was expected

select to_char(to_date(':Effective_date', 'dd/mm/yyyy'), 'yyyy-mm-dd hh:mm') from dual

Please help

Thanks

Added on Oct 11 2019

#oracle, #variable

12 comments

3,665 views