Updating Date Field Error ORA-01858

From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Thu, 1 Mar 2001 11:37:49 +1100
Message-ID: <TEgn6.5679$v5.21071@newsfeeds.bigpond.com>

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