is there a function to calculate from a time field like hh:mm:ss , the total minutes ?
I don't know how to do it
Thanks in advance for your help
Maybe you can use the functions hour and minute?
LOAD * INLINE [ time 15:10:33];load hour((time))*60 + minute(time) as TotalMinutesresident t_time; br
I've two time stamp fields and I calculate the duration by Interval(FinalTime - Starttime) and I get the correct value in hh:mm:ss. Now I would transform the result in minutes, but I'm getting wrong values.
I tried by hour and minute without success.
Did you try the interval function as given below?
Retrieving data ...