Re: NLS_DATE_FORMAT not working on client

normally the NLS_LANG parameter is put in the registery and set to AMERICAN_AMERICA.WE8ISO8859P1. The default date format for from this parameter for american territory is DD-MON-YY. so if you include NLS_DATE_FORMAT='DD-MON-RRRR' you will see different results for select sysdate from dual;
if you have 16bit apps like oracle financials you need to make this entry in oracle.ini
as 16bit applications don't look into the registery.

Sudershan Virdi

William Dangren wrote:

> 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
Received on Thu Jul 29 1999 - 21:46:17 CDT