Timestamp format

Raya — Tue, 21 May 2024 15:08:09 GMT

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

Re: Timestamp format

brunobertels — Tue, 21 May 2024 15:41:11 GMT

use this instead :

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