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

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


      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!