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