Re: NLS_DATE_FORMAT not working on client

William Dangren wrote at 29-Jul-99 22:48:29 on the subject NLS_DATE_FORMAT not working on client:

>We have it set in the init file to one format and when you view the
>format in the v$parameter it shows the correct format that is in the
>init file. The problem is if you go to the client and select sysdate
>from dual it shows the old format. If you select sysdate from dual on
>the server it is correct. The system was bounced and the user is
>always the same. Is there a known bug in SQL*NET? Thank you for any
>input.

Well, it's not a bug, it's a feature. ;-) Every client has its own setting of nls_date_format. On Windows clients for example there is a setting in the registry. You can also set the nls_date_format for every single session using

alter session set nls_date_format=<format string>;

>Bill

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |