Oracle Transactional Business Intelligence Idea Lab

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

21
Views
0
Comments

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

 

Doc ID 1664251.1

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

4
4 votes

Submitted · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.