1 Reply Latest reply on Feb 7, 2020 6:40 PM by Vikas Panwar

    format transformation of current_ts in ogg for big data 12.3

    3831381

      in the target oracle goldegnate for big data,

      i want to transformate current_ts format "current_ts":"2020-01-28 09:53:30.716000" to "current_ts":"2020/01/28 09:53:30.716000" .

      i'm using json format.

       

        • 1. Re: format transformation of current_ts in ogg for big data 12.3
          Vikas Panwar

          Hi 3831381,

           

          by default it will have ISO-8601

          so far I was not able to change this to any other as you mentioned but can think a lengthy way

          extract year, mon, date, sec, precision and then concatenate them as required.

           

          Instead i requested target application to read from the provided format and do the changes as required (probably on their side its easier)

           

          lets see if somebody else has some other alternative.

           

          Mark this helpful, correct or like it appropriately. This will help others too.

           

          3831381  -- did this help you ?

           

          -VP