topic Extract timestamp from timezone in Integration, Extension & APIs

Extract timestamp from timezone

Neeraja005 — Sat, 16 Nov 2024 17:26:19 GMT

Hello People,

I have a timezone format stored in my Dynamo db: " 2019-12-05T13:30:24.314Z"

I want to convert it to a timestamp and calculate the response time between two different timestamps.

Can someone help me with this conversion? I am new to Qliksense scripts and time formats and unable to figure it out.

Thanks in Advance

Regards,

Neeraja Upadrasta

Taoufiq_Zarra — Mon, 01 Mar 2021 09:56:45 GMT

if timestamp# not working you can format your field as :

=timestamp#(subfield(subfield(Field,'T',2),'Z',1),'hh:mm:ss.FFF')

then you can apply time function, for example to exatrct hour :

=hour(timestamp#(subfield(subfield(Field,'T',2),'Z',1),'hh:mm:ss.FFF')) return

you can also use interval or ...

MayilVahanan — Mon, 01 Mar 2021 10:03:57 GMT

Try like below

Timestamp(Timestamp#('2019-12-05T13:30:24.314Z','YYYY-MM-DDTHH:mm:ss.fff'),'YYYY-MM-DD HH:mm:ss')

-- Convert into timestamp format

=Hour(Timestamp(Timestamp#('2019-12-05T13:30:24.314Z','YYYY-MM-DDTHH:mm:ss.fff'),'YYYY-MM-DD HH:mm:ss'))

gives 13

Neeraja005 — Wed, 03 Mar 2021 08:32:49 GMT

Thank you for the quick reply I could use the timestamp to extract timezone as timestamp and then used the time to calculate response time.

time(timestamp(timestamp#("Date_Field"))) as "preffered_name"