Hi
How can we change global date format in obiee. I don't want to change this in column properties.
convert from 'yyyy/mm/dd' (2017/06/29) to 'dd/mmm/yyyy' (29/Jun/2017).
Hi,
You don't say which version you're using but this should help you: https://www.rittmanmead.com/blog/2014/02/date-formatting-in-obiee-11g-setting-the-default-locale-for-users/
Depends...do you just want to do GUI tricks or actually change how it technically comes across for the whole platform?
Because the latter means NQSConfig.ini
Hi Berg,
Thanks for response!
I'm using OBIEE 12.2.1.2.0. I need same date format(eg. 30/Jun/2017 ) in the whole platform. I tried to change date tags as below in NQSConfig.ini, but the BI services are failed
DATE_TIME_DISPLAY_FORMAT = "dd/mmm/yyyy hh:mi:ss";
DATE_DISPLAY_FORMAT = "dd/mmm/yyyy";
TIME_DISPLAY_FORMAT = "hh:mi:ss";
Technically it's "mm" - the "mmm" is then your locale settings. There's a tech layer and a presentation layer.