Re: Help with NLS_DATE_FORMAT

Here is 3 system tables containing NLS parameters :

SELECT * FROM NLS_SESSION_PARAMETERS;
SELECT * FROM NLS_INSTANCE_PARAMETERS;
SELECT * FROM NLS_DATABASE_PARAMETERS;

Session parameters can be modified with (by exemple)

ALTER SESSION SET NLS_LANGUAGE = 'FRENCH';
ALTER SESSION SET NLS_TERRITORY = 'FRANCE';
ALTER SESSION SET NLS_CURRENCY = 'F';
ALTER SESSION SET NLS_ISO_CURRENCY = 'FRANCE';
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';
ALTER SESSION SET NLS_DATE_LANGUAGE = 'FRENCH';
ALTER SESSION SET NLS_SORT = 'BINARY';
ALTER SESSION SET NLS_CALENDAR = 'GREGORIAN';
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD';

Perhaps INSTANCE and DATABASE parameters could be modified BY

'ALTER DATABASE' or 'ALTER INSTANCE' ???

alt_at_interchange.co.uk a écrit dans le message <7bmeqh$m2g$1_at_nnrp1.dejanews.com>...
>Oracle 7.3.2.3
>sqlnet 2.3.4
>decalpha running decunix
>
>
>Any idea whats going on here?
>
>We've got NLS_DATE_FORMAT="YYYYMMDD" set in the init.ora file and when you
use
>sqlplus on the server it returns the date in the correct format eg
>
>select sysdate from dual;
>
>sysdate
>---------
>19990304
>
>When you use sqlplus from the client you get a different result!
>
>select sysdate from dual;
>
>sysdate
>---------
>03-MAR-99
>
>Could someone please explain why this is happening. It's causing havoc with
>our client application which expects the date in the YYYYMMDD format.
>
>I'd be grateful for a reply to alt_at_interchange.co.uk
>
>Thanks for the help.
>
>Al
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 04 1999 - 15:02:12 CST