Re: Updating Date Field Error ORA-01858

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 01 Mar 2001 07:42:18 +0100
Message-ID: <fnrr9t06ipecri32h5vef4j0bna164i9hg@4ax.com>

On Thu, 1 Mar 2001 11:37:49 +1100, "Peta Griffith" <peta_at_dataspeed.com.au> wrote:

>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
>

MMM should be MON with the data you are supplying. You also may need to replace the - in the format mask by / as you are using them in your date. Please refer to the sql reference manual for the various available date formats.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Mar 01 2001 - 00:42:18 CST