Converting from one time format to another

[#1]

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]

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

[hic · Accepted solution]

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