Re: date problem

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 26 Jan 2007 09:35:56 +0100
Message-ID: <51tsqvF1m14s5U1@mid.individual.net>

On 25.01.2007 20:05, Jeff Kish wrote:
> On Thu, 25 Jan 2007 13:51:05 -0500, Jeff Kish <jeff.kish_at_mro.com> wrote:
>

>>>> INSERT INTO table( id, newpass, thedate )VALUES ( :userid, :pswd,
>>>>          	TO_DATE( :thedate, 'DY MON DD HH24:MI:SS YYYY' ) )

> I found out that this insert with the TO_DATE works if a hard coded 'Dec' is
> changed to the Spanish abbreviation 'Dic'.
>
> Is this then driven by the character set of the server?
> I'm not sure if I need to check any client settings, or how to.

Could be server or session depending on whether session specific settings are made (could also be implicit, I don't know your access library).

A general remark: Using a numeric month value is much more robust - as you just found out. So if you have a chance to change that, that's what I'd do.

Kind regards

robert Received on Fri Jan 26 2007 - 02:35:56 CST