converting time

[#1]

Hello All,

Could you please help me convert 0530 into '05:30:00' in the load script.

Many Thanks,

Hasvine

[sunny_talwar · Accepted solution]

Try this:

Time(Time#(TimeField, 'hhmm'), 'hh:mm:ss') as TimeField

[#3]

Thank you.

Working great.

KR,

Hasvine

[sunny_talwar]

Great

I am glad it works.

Best,

Sunny

[maxgro]

you need the interpretation function Time# to convert the input value to a number

Time#('0530', 'hhmm')

then if you want a different format from the format you have at the beginning of your QlikView (.qvw), mine is

SET TimeFormat='hh:mm:ss';

you need the formatting function Time

Time(Time#('0530', 'hhmm'), 'hh:mm:ss')

replace 0530 with your field

and if you want more detail

QlikView Date fields

The Date Function