Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to change the NLS_DATE_FORMAT permanently

548091Jun 1 2007 — edited Jun 1 2007

Hi,
I have query that how to change the NLS_DATE_FORMAT permanently after the new database has been created.

The new database was created with this parameter as “DD-MON-RR” and I want to change it to “DD.MM.YYYY” on a permanent basis.

Looking forward to your prompt solution.
Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2007

Added on Jun 1 2007

#general-database-discussions

16 comments

10,942 views