topic Re: Number to timestamp in QlikView

Number to timestamp

Tue, 26 Aug 2014 12:41:33 GMT

hi,

Which function in QV can I use to convert a number eg 54620 to hh:mm:ss?

Regards,

Kevin

Re: Number to timestamp

ashfaq_haseeb — Tue, 26 Aug 2014 12:44:33 GMT

Hi,

what is your expected output here.

Try like below

=interval(timestamp#(54620, 's'), 'hh:mm:ss') --> 15:10:20

=Time#(Left(Repeat('0',6-Len(54620))&54620,2) & ':' & Mid(Repeat('0',6-Len(54620))&54620,3,2)& ':' &Right(Repeat('0',6-Len(54620))&54620,2),'hh:mm:ss') --> Returns 05:46:20

Regards

ASHFAQ

Re: Number to timestamp

amit_saini — Tue, 26 Aug 2014 12:47:21 GMT

Kevin,

Like this????

=Time(Time#('9690','ss'),'hh:mm:ss') ---------2:41:30 (Output)

Thanks,

Re: Number to timestamp

PrashantSangle — Tue, 26 Aug 2014 12:53:31 GMT

Hi,

Use like

Time(54620,'hh:mm:ss')

Regards

Re: Number to timestamp

MarcoWedel — Tue, 26 Aug 2014 13:39:21 GMT

Hi,

maybe like this?:

hope this helps

regards

Marco

Re: Number to timestamp

manideep78 — Tue, 26 Aug 2014 13:47:35 GMT

Like this

=TimeStamp(Timestamp#('54620','hmmss'),'hh:mm:ss')

Re: Number to timestamp

jagan — Tue, 26 Aug 2014 14:58:00 GMT

Hi Kevin,

Try like this

If time is in hmmss format

TimeStamp(Timestamp#('54620','hmmss'),'hh:mm:ss')

If 54620 is seconds then try like this

=interval(timestamp#(54620, 's'), 'hh:mm:ss') --> 15:10:20

Regards,

Jagan.

Re: Number to timestamp

Tue, 02 Sep 2014 09:31:48 GMT

works! cheers

Re: Number to timestamp

Tue, 02 Sep 2014 09:32:06 GMT

works! cheers!

Re: Number to timestamp

Tue, 02 Sep 2014 09:32:34 GMT

didn't return the correct timestamp, cheers though.

Re: Number to timestamp

Tue, 02 Sep 2014 09:33:05 GMT

works! cheers!

Re: Number to timestamp

amit_saini — Tue, 02 Sep 2014 09:34:45 GMT

Kevin,

Please close the thread by marking correct or helpful answer.

Thanks,