Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a num value =2 this is really 00:00:02 on the clock. I also have 92433 which is 09:24:33
I want the field to be formated as a time value like hh:mm:ss. SQL code or in qlikview is OK.
Hi,
another solution:
LOAD *,
Time(Mod(val,100)/86400+Mod(Div(val,100),100)/1440+Div(val,10000)/24) as Time
INLINE [
val
113
1256
211318
144036
2
];
hope this helps
regards
Marco
... and one more:
Time(Time#(Num(val, '000000'), 'hhmmss'),'hh:mm:ss')
hope this helps
regards
Marco