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!

Convert smalldatetime type SQL format to Date in OBIEE

Naresh Kumar-OracleOct 13 2010 — edited Oct 20 2010

I have a SQL database which holds date in the smalldatetime type SQL format. I want to read this date in the OBIEE. How I can achieve this. I didn't find any direct CAST for this OBIEE Answers.

thanks,
Naresh

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2010

Added on Oct 13 2010

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

6 comments

2,151 views