Time in hh:mm:ss

[ferha_jafri]

Hello Everyone,

I need help asap , it is urgent , i have time field in which the time is mentioned in a format is 31245 means 3 hr 12 min and 45 sec, how i can get in the format as 03:12:45.If anyone knows the ans please reply asap.I am attaching a sample.

[amit_saini]

Hi Ferha,

Please use these:

Time(Time#(fieldname,'ss'),'hh:mm:ss')

OR

dual( Date(TS,'YYYY-MM-DD') &'T' & time(TS,'hh:mm:ss'), num(TS) ) as Timestamp,

OR

trim(Time(timestamp, 'hh:mm:ss')) as my_time

Thanks,

AS

[#3]

hi

try this

Time(Time#(fieldname,'hmmss'),'hh:mm:ss')  as NewTime

******************************************

in text object try this

=Time(Time#('31245','hmmss'),'hh:mm:ss') 

[preminqlik · Accepted solution]

time(time#(num(fieldname,'000000'),'hhmmss'),'hh:mm:ss')                    as               TIME

[ferha_jafri]

Thank you So much Vishwaranjan

[qlikpahadi07]

Modifying the logic try this in text box

=if(len(Time) =5, Time(Time#(Time,'hmmss'),'hh:mm:ss') ,

  Time(Time#(Time,'hhmmss'),'hh:mm:ss') )

because if values are "145650" above expression will work for both