Re: TO_CHAR function & client machine local configuration

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
>

1. you can include the NLS_DATE_FORMAT in the to_char function
2. Microsux supports connecting to a network registry *and* locking the PC, so end-users can't change the registry
3. create an on-logon trigger that sets the proper format.

--
Sybrand Bakker, Senior Oracle DBA