Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_DATE_FORMAT not working on client

Re: NLS_DATE_FORMAT not working on client

From: Nguyen dao <ndao_at_hawaii.edu>
Date: Wed, 28 Jul 1999 23:39:30 -1000
Message-ID: <37a17226@coconut-wireless>


If client machine is Win32 platform, set NLS_DATE_FORMAT= XXXX in the registry file. If the client machine is UNIX, set NLS_DATE_FORMAt with an environment variable.

William Dangren wrote in message <37A0CC2D.ED7CE53A_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
>
>
Received on Thu Jul 29 1999 - 04:39:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US