Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Provide sample data or file where you have problem in getting correct result.
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