Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to change date format in OBIEE?

Received Response
23
Views
4
Comments
DollyG
DollyG Rank 5 - Community Champion
edited August 2024 in Oracle Analytics Cloud and Server

Hi All,

I have the date format in my DB as: '31-DEC-17'

and the timestamp for for the same is:

"31/12/2017

12:00:00"

I need the date in the following format say: Jan'17.

How can I achieve this?

Regards,

Dolly

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    pastedImage_0.png

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    To add to Joel's reply, the best way I find when you want something that is not out of the box is to use the nearest equivalent and then change the drop box to custom - the custom will then be populated with a starter for ten that you can subtly edit to get what you want, without starting from nothing...

  • Joel
    Joel Rank 8 - Analytics Strategist

    totally agree with @Robert Angel. it's a tip that I also use...

  • DollyG
    DollyG Rank 5 - Community Champion

    Thanks Joel!

    It worked for me.