Re: strange behaviour using to_char to return daynumber

From: mich $at work$ <someone_at_mail.com>
Date: Mon, 24 Apr 2006 14:22:31 +0100
Message-ID: <bh43g.23$AH6.4609@news1-hme0>

Thanks for the reply.

I thought the client would take on the NLS_TERRITORY and NLS_DATE_FORMAT from the instance...

M.
<sybrandb_at_yahoo.com> wrote in message
news:1145883640.808853.66970_at_e56g2000cwe.googlegroups.com...
> Could well be a different NLS_TERRITORY or NLS_DATE_FORMAT setting on
> client and server. One side conforms to the ANSI definition and the
> other side conforms to the ISO definition. When not set, the settings
> on Windoze depend on the territory settings in the control panel.
> Also connecting from a higher version client to a lower version
> database isn't exactly downwards compatibility and may result in
> unknown problems, especially as 8.1.7.3 is desupported.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
Received on Mon Apr 24 2006 - 08:22:31 CDT