topic Re: Time Format in QlikView

Time Format

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We have pulled the report_time field directly from DB and it shows as below,

Report_time = 100000,110000,120000 (Actually it means 10,11,12)

Here i need to convert this into HH:MM format.Please suggest on this.

Thanks..

swuehl — Thu, 31 Mar 2016 10:16:59 GMT

Mybe like

Time(Time#(Report_time,'hhmmss'),'hh:mm') as NewTime

sunny_talwar — Thu, 31 Mar 2016 10:17:27 GMT

May be this in the script:

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

Chanty4u — Thu, 31 Mar 2016 10:18:33 GMT

try this

timestamp(alt(TImestamp#([Report_Time],'DD-MM-YYYY hh:mm:ss'),

TImestamp#([Report_Time],'DD-MMM-YY hh.mm.ss.fff TT')),' HH:MM') as date