Printable View
hi guys,
i want to change the parameter nls_date_format.. I know i can do it with alter session. I can also do it by changing it in the registry.. Can i add the paramter in my pfile.. I tried doing that too. I added the parameter then restarted the database. But it is not working.. Any suggestions..
Thanks in advance..
Should be fine:
http://otn.oracle.com/docs/products/...18.htm#2053228
Perhaps your client tool is overriding this with the value from the registry.
[Edited by TimHall on 01-24-2002 at 06:54 AM]
You need to change at registry and the pfile
NLS_DATE_FORMAT=
if you try to acces the database from client you also need to change/add the NLS_DATE_FORMAT at the client's registry.
Hi Tim,
Thank you for providing such a good link on this site...
Zahid
Oracle DBA
Computer Associates
Vancouver, Canada.
Glad to help :)