Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Ability to override Oracle set NLS_DATE_LANGUAGE default value of NUMERIC_DATE_LANGUAGE
Sudhesh Nayak
Rank 3 - Community Apprentice
Organization Name
Rutgers, The State University Of New Jersey
Description
To conform to I18N standards, Oracle has recently made changes to the NLS_DATE_LANGUAGE. This means that where ever to_char function is used on the date field for reformatting, it will be required to include NLS_DATE_LANGUAGE.
Can Oracle provide a way for the ERP clients to override Oracle set NLS_DATE_LANGUAGE default value of NUMERIC_DATE_LANGUAGE to something else as a default (e.g. AMERICAN)? A possible place where this could be made available is in BI Runtime Configuration - Properties.
select to_char(sysdate, 'DD-MON-YYYY','NLS_DATE_LANGUAGE=AMERICAN') from dual
Use Case and Business Need
Need the ability to override Oracle set NLS_DATE_LANGUAGE default value of NUMERIC_DATE_LANGUAGE
Original Idea Number: d0661aa081
Tagged:
4