topic Re: Converting from one time format to another in QlikView

Converting from one time format to another

Thu, 17 Sep 2015 13:17:08 GMT

In my initial TEMP load Im converting the timestamp into time as per the below format:

Text(Time(round([Settlement timestamp], (1/8640000)), 'hh:mm:ss:ffffff')) as SettlementTime,

However in the final load I need to convert it again as per below,

Time(SettlementTime, 'hh:mm:ss') as SettlementTime_FINAL,

but Im getting null values.

any ideas?

MK_QSL — Thu, 17 Sep 2015 13:23:32 GMT

Provide sample data or file where you have problem in getting correct result.

hic — Thu, 17 Sep 2015 13:28:55 GMT

You don't need to create a text from it. If you just use

Time(round([Settlement timestamp], 1/8640000 ), 'hh:mm:ss:ffffff') as SettlementTime,

it should work directly. You will see the text, but it will also have a numeric value.

HIC