Global Date format

DB_Home

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).

Pedro F

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/

Christian Berg-0racle

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

DB_Home

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";

Christian Berg-0racle

Technically it's "mm" - the "mmm" is then your locale settings. There's a tech layer and a presentation layer.