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!

Impact of changing "NLS_DATE_FORMAT" and "NLS_DATE_LANGUAGE" parameters

karvNov 19 2009 — edited Nov 19 2009

Hi All,

We would like to change the below NLS parameters due to requirement for one schema user, and want to change in the init.ora file.

Current Settings:

nls_date_format = RRRR-MM-DD-HH24:MI
nls_language = AMERICAN
nls_date_language =

Required Settings:

nls_date_format = DD-MON-YYYY HH24:MI:SS
nls_language = AMERICAN
nls_date_language = ENGLISH

DB Version: 9.2.0.8

Could anyone tell us what will be the impact for the existing code/other schema users.

Thanks in advance,
karv

Edited by: karv on Nov 19, 2009 2:57 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2009

Added on Nov 19 2009

#general-database-discussions

4 comments

690 views