| How to set NLS_DATE on linux [message #144520] |
Wed, 26 October 2005 20:35  |
evoradba
Messages: 144
Registered: April 2005
Location: Canada
|
Senior Member |
|
|
Hello again
I have oracle installation on linux 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, this is my configuration, also Im not using any spfile,
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
SQL> select name, value from v$system_parameter where name='nls_date_format';
nls_date_format
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
|
|
|
|
| Re: How to set NLS_DATE on linux [message #145772 is a reply to message #144520] |
Sun, 06 November 2005 14:01  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
It's working for me (Oracle 10g Release 2):
SQL> ALTER SYSTEM SET nls_date_format = 'DD-MON-YYYY HH24:MI:SS' SCOPE=SPFILE;
System altered.
SQL> STARTUP FORCE
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218292 bytes
Variable Size 75499788 bytes
Database Buffers 83886080 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> SELECT sysdate FROM dual;
SYSDATE
--------------------
06-NOV-2005 22:00:33
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
