This discussion is archived
8 Replies Latest reply: Feb 11, 2013 6:40 AM by AhamedRafeeque RSS

ORA-01858: a non-numeric character was found where a numeric was expected

user7197586 Newbie
Currently Being Moderated
Hi

I am trying to escecute the query but gives error as - "ORA-01858: a non-numeric character was found where a numeric was expected"

My qyery is -

SELECT TO_DATE(EMP_DOB,'DD.MM.YYYY') EMP_DOB,
TO_DATE(EMP_SATTLEMENT_DATE,'DD.MM.YYYY') EMP_SATTLEMENT_DATE
FROM PF_PERSONAL_DTL_TXN2011
WHERE PF_NUM IS NOT NULL

when i am tring to execute this query in Toad gives above error as -

"ORA-01858: a non-numeric character was found where a numeric was expected"

kindly suggest the solution

Regards,
Sachin

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points