I am having a very strange issue, i added the following line to my init.ora and restarted the database:
NLS_DATE_FORMAT='MM/DD/YYYY'
after this from the telnet unix window sqlplus i am getting the following:
select sysdate from dual;
SYSDATE
----------
04/18/2002
and
select * from v$nls_parameters
VALUE
----------------------------------------------------------------
NLS_DATE_FORMAT
MM/DD/YYYY

but when I connect to the same database from sqlplus on my machine here is what i get:
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_DATE_FORMAT
DD-MON-RR
select sysdate from dual;
SYSDATE
---------
18-APR-02

why are these different on my local machine???
but in the view v$parameter it shows the changed value:
mm/dd/yyyy
Please advise