-
Hello,
I am using Oracle 8.1.6i for Linux (Redhat 6.2).
I would like to alter NLS_DATE_FORMAT. As I modified initsid.ora, e.g.
NLS_DATE_FORMAT = "yyyymmdd"
when I type "Select sysdate from dual", it only shows "DD-MON-YY". And I've checked parameter by using "show parameters". I found that nls_date_format is updated. What's wrong with it?
Thanx a lot.
Joe
-
could you check following tables:
v$nls_database_parameter
v$nls_instance_parameter
v$nls_session_parameter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|