Re: date problem

On Fri, 26 Jan 2007 09:35:56 +0100, Robert Klemme <shortcutter_at_googlemail.com> wrote:

>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

thanks for your thoughts.
I don't believe we do any session dependent (session scope) settings. I'll look into using the numbers for hard coded situations.

thanks again
very much
Jeff Kish Received on Fri Jan 26 2007 - 12:44:32 CST