1 Reply Latest reply: Apr 12, 2011 1:11 PM by SaichandVaranasi RSS

    How to change date format in OBIEE

    Yala
      Hello

      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!