Skip to Main Content
Forums

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!

Add date format in Prompt of OBIEE

Rai Qaiser HussainJan 25 2019 — edited Jan 25 2019

Hi

I want to add date format in promot of dashboard and followed the following document but fail

How to Dispaly date type data to a format such as 'DD/MM/YYYY' (Doc ID 963352.1)

Used below query in SQL of Prompt

SELECT EVALUATE('TO_CHAR("Time"."Calendar Date")',"Time"."Calendar Date" , 'DD/MM/YYYY')

FROM   "Data Management"

ORDER  BY "Time"."Calendar Date" DESC FETCH FIRST 5 ROWS ONLY

what is wrong with this query/ format used
Comments
Post Details
Added on Jan 25 2019
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #prompt
2 comments
372 views