Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Updating Date Field Error ORA-01858
using visual basic and the Oracle ODBC Driver Executing this statement returns the error ORA-01858: a non numeric character was found where a numeric was expected.
UPDATE tblBPStudents SET tblBPStudents.[No of Replacements] = 0, tblBPStudents.[Last Replacement Date] = TO_DATE('29/Dec/1899' ,'DD-MMM-YYYY') Where tblBPStudents.[No of Replacements] <> 0
Thanks
Paul
Received on Wed Feb 28 2001 - 18:37:49 CST