Date format uppercase in OBIEE analysis — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Date format uppercase in OBIEE analysis

Received Response
21
Views
1
Comments
user6287828
user6287828 Rank 2 - Community Beginner

Hello

I am intending to show date in an OBIEE report in the following format.

12-JAN-2016

To do this I am going to column properties -> data format-> select "custom" -> and specify DD-MMM-YYYY.

I am getting the date output as 12-Jan-2016.

So the problem is Month. How can I get JAN instead of Jan .

I also tried DD-MON-YYYY

Thanks

Answers