Create Date Time Formatting

[#1]

Hi Community

Please find the attached QVW file and advice on how i can format my time field .

e.g

253 to 00:02:53

20904 to 02:09:04

Regards

Mutshidzi

[sunny_talwar · Accepted solution]

Try something like this:

LOAD 

    WI_CT as [Creation Time],

    Interval(Interval#(Num(WI_CT, '000000'), 'hhmmss'), 'hh:mm:ss') as NewCreationTime

FROM

(ooxml, embedded labels, table is Multi0103);

[Anonymous]

Did you check this?

The Date Function

Date/Time format