Timestamp format

[Raya]

Hi Qlik Experts,

I need some help in getting the time stamp value. In my source i am getting value in this format (

2024-05-21 03:32:32.218961 UTC. in Qlik. Qlik is returning value as 2024-05-21 03:32:32.218000.

i am formatting above number using date function as Date(Datefield,'YYYY-MM-DD hh:mm:ss.ffffff')&' UTC'.

I am getting result as 2024-05-21 03:32:32.218000 UTC. Just looking to get exact value for 2024-05-21 03:32:32.218961 UTC

[brunobertels]

Hi 

use this instead : 

Timestamp#('2024-05-21 03:32:32.218961 UTC','YYYY-MM-DD hh:mm:ss.ffffff') &' UTC.'