Re: Oracle-Error ORA01843 - not a valid month

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 15 Aug 2001 21:26:43 +0200
Message-ID: <u5jlnt4orbp9mukatt2no36regnjceps6o@4ax.com>

On 13 Aug 2001 06:24:03 -0700, sandrahagmann_at_vinzenz.de (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

Registry

in HKEY\local_machine\software\oracle
add the string variable
NLS_DATE_FORMAT = "DD.MM.YYYY" Regards,

Sybrand Bakker, Oracle DBA Received on Wed Aug 15 2001 - 14:26:43 CDT