This content has been marked as final. Show 4 replies
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,