Set NLS_DATE in oracle

From: <evoradba_at_yahoo.ca>
Date: 27 Oct 2005 04:15:12 -0700
Message-ID: <1130411712.502949.261720@z14g2000cwz.googlegroups.com>

I have oracle installation on linux Oracle 9i now I need to set the NLS_DATE to display the hour and minutes I have tried everytime possible, but it seems that there is something else missing,Im not using the spfile, only the init.ora, this is my configuration, SQL> select name,value from v$parameter where name='nls_date_format'; nls_date_format
DD-MON-YYYY HH24:MI:SS
SQL> select sysdate from dual;

SYSDATE

---

26-OCT-05 SQL> select name,value from v$parameter where name='nls_date_format';

Thank you
Maria
nls_date_format
DD-MON-YYYY HH24:MI:SS SQL> select name,value from v$parameter2 where name='nls_date_format';

nls_date_format
DD-MON-YYYY HH24:MI:SS SQL> select name,value from v$spparameter where name='nls_date_format'; nls_date_format

SQL> select * from v$nls_parameters where parameter='NLS_DATE_FORMAT';

NLS_DATE_FORMAT
DD-MON-RR DD-MON-YYYY HH24:MI:SS
SQL> select name, value from v$system_parameter where name='nls_date_format';

nls_date_format
DD-MON-YYYY HH24:MI:SS this is the init.ora

nls_date_format='DD-MON-YYYY HH24:MI:SS' I have also bounced oracle counteless times and no luck, and this works per session, but I need on server wide

what do I need to do so that the select sysdate from dual will display

alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';

Session altered.

SQL> select sysdate from dual;

SYSDATE

---

26-OCT-2005 21:33:00 Received on Thu Oct 27 2005 - 06:15:12 CDT