4 Replies Latest reply: Nov 27, 2015 4:44 AM by Hasvine Dhurmea RSS

    Coverttolocaltime

    Hasvine Dhurmea

      Hi All,

       

      I am trying to convert the format 29/08/2015 03:05:37 to time only but the problem is that I need to add 4 hours to it so that it reflect GMT+04:00.

       

      So my answer should be 07:05:37.

       

      My current line i my loading script is as below:

       

      Time(Frac([createdtime]), 'hh:mm:ss') as Time,

       

      Kind Regards,

       

      Hasvine