Setting NLS_TIMESTAMP_FORMAT global parameter
Hi everyone,
I am trying to set the NLS_TIMESTAMP_FORMAT parameter globally on my Oracle database. I shutdown the database and edit the initialization file that I use during startup. I added the following:
nls_timestamp_format = 'MM-DD-YYYY HH:MI:SS AM'
However, the change is never reflected. Also when I shut down the database, the initialization file is edited to:
nls_timestamp_format = AM
I am not sure what I am doing wrong. I would really appreciate any suggestion or help.
Thanks,
Pankaj
|