Re: TO_CHAR function & client machine local configuration

From: Michel Cadot <micadot2removethat_at_free.fr>
Date: Tue, 11 Nov 2003 20:44:27 +0100
Message-ID: <3fb13bfe$0$13306$626a54ce@news.free.fr>

"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> a écrit dans le message de news:55d2rv0jpv89rf15m6lfpfm7403pr83dqq_at_4ax.com...
> On Tue, 11 Nov 2003 18:01:14 +0100, "Jon" <aaa_at_bbb.ccc> wrote:
>
> >when using the followin function: TO_CHAR(SYSDATE, 'DY') or TO_CHAR(SYSDATE,
> >'D'), depending the client machine from which I run the function, the result
> >changes. Can I use any function that could give me universally the same
> >result, not depending on the local configuration of the client machine but
> >the server configuration. Thanks
> >
>
> a) you can include the NLS_DATE_FORMAT in the to_char function

NLS_DATE_LANGUAGE for format element 'DY'. Format element 'D' result depends on NLS_TERRITORY and you can't use it in the to_char function (in 8i, don't know in 9i).

Michel Cadot Received on Tue Nov 11 2003 - 13:44:27 CST