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


      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,