4 Replies Latest reply on Jul 16, 2019 2:24 PM by 4043917

    OBIEE - day of year to date - cannot figure out!

    4043917

      hello all - hoping someone here has tried this and can offer some help.

       

      i am trying to do the following in OBIEE:

       

      select cast(DATEADD(Day,cast(substring('19087',3,3) as int),DATEADD(year,concat('20',left('19087',2))-1900,0)) as date) as mdt

       

      what this does in SQL is takes the year, left 2 digits, and the DAY of the year, 087, and turns it in to 2019-03-29

       

      i CANNOT figure this out...at all in OBIEE.

       

      can anyone help?

       

      thank you!