2 Replies Latest reply on Jan 25, 2019 4:29 PM by Rai Qaiser Hussain

    Add date format in Prompt of OBIEE

    Rai Qaiser Hussain


      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