How to change date format in OBIEE?

DollyG

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

Joel

Robert Angel

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

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

DollyG

Thanks Joel!

It worked for me.