Re: NLS_DATE_FORMAT not working on client

William Dangren <wdangren_at_navisent.com> :

> 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.
>
> Bill
>
> --
> William Dangren
> Navis Enterprises
> 407.348.6401
> 800.219.0207
>
>

This is not a bug and it bites almost everyone until they learn how it works. Simply put, the server's setting of NLS_DATE_FORMAT (and all other similar settings) has absolutely nothing to do with the corresponding setting on the client. You must also set the parameter when you start the client. This can be easily accomplished by creating a file specifically named logon.sql in the client's startup directory. Commands placed in this file will automatically be executed each time the client app is started, but NOT each time the client reconnects.

Tim Received on Thu Jul 29 1999 - 17:49:32 CDT