Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_DATE_FORMAT not working on client
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