8 Replies Latest reply: Feb 11, 2013 8:40 AM by Ahamed Rafeeque RSS

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

    user7197586
      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