Microseconds format to Timestamp

[Suraj_Kendre]

Hello,

I have field of date which is in microseconds wanted to convert to a timestamp like 'DD/MM/YYYY HH:MM'.

Please help with it.

[igoralcantara · Accepted solution]

I have some bad news. Qlik time precision is limited to the seconds. It does not support milliseconds.

What you can try is to store it as a number with lots of decimal places, but when to show it, you can only who to the milliseconds level.

Unless someone has some creative solution (like calculating the milliseconds and concatenating, but that will make the field a string, not a timestamp).

[tresesco · Accepted solution]

@Suraj_Kendre , @igoralcantara 
I have a good news! 
Yes, qlik has a formatting for miliseconds or such fraction of seconds, use 'f' for the same.

Something like : Timestamp(Timestamp#(20240409004758500000, 'YYYYMMDDhhmmssffffff'))

[Suraj_Kendre]

Thank you so much!!!

Its working!