Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to extract month from date column in OBIEE?

891471Oct 3 2011 — edited Oct 3 2011

Hi Gurus,

I have a physical column XX_Date and XX_Month. XX_Month is a newly added column and I need to extract data for XX_Month from XX_Date. Pls help me in explaining where and how should I write the EXTRACT function.

Thanks in advance!!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2011

Added on Oct 3 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

8 comments

9,122 views