Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 12, 2011 1:11 PM by
How to change date format in OBIEE
Apr 12, 2011 1:05 PM
I have a need to change the date column to a varchar column in OBIEE..
The date column stores data in the format of 'YYYY/MM/DD', I need to change this to a varchar column with this format 'YYYYMM'..
Since I am pointing directly at the transactional database, I can't make any changes at the database level, so I will have to do it in OBIEE layer, any ideas how it could be done?
Many thanks in advance!
This content has been marked as final.
Show 1 reply
Re: How to change date format in OBIEE
Apr 12, 2011 1:11 PM
in response to
Refer : http://varanasisaichand.blogspot.com/2010/01/how-to-change-data-format-to-our-custom.html