Re: Oracle-Error ORA01843 - not a valid month

From: Markus Stuhlpfarrer <mstuhlpfarrer_at_hollomey.com>
Date: Mon, 13 Aug 2001 13:46:08 GMT
Message-ID: <3B77D9AE.2749E6E5@hollomey.com>

make the statemenet with
to_date('30.12.2001','DD.MM.JJJJ')
or change the NLS settings on your DB that way, that this is the standard format

Sandra wrote:

> Hello,
>
> i'll make an update on a sql-table (oracle) with delphi. in the
> update-statement is a date-field to change. The following errormessage
> appears:
>
> ORA01843 - not a valid month
>
> The Short-Date-Format is DD.MM.JJJJ (german date)! Who knows, where
> and how i can configure the date-format. in the countryconfiguration,
> the BDE...???
>
> TIA!
> Sandra
Received on Mon Aug 13 2001 - 08:46:08 CDT