topic Re: Convert timestamp with timezone to UTC in QlikView

Convert timestamp with timezone to UTC

Anonymous — Tue, 28 Nov 2017 10:36:35 GMT

Hi,

I have postgres connect to the Qlik Sense. Inside postgres table, one of the field is of type timestamp with timezone

This mean:

DB field	Actual UTC time (not in DB)
2017-08-22 01:08:56+02	2017-08-21 23:08:56
2017-08-22 14:29:10+02	2017-08-22 12:29:10

For some calculation I need to have UTC time.

How to get the UCT time inside qlik sense.

Also, If I would like to convert to another local time (to show to a customer in another country).

ConvertToLocalTime is converting from UTC to selected local time, and not from local time to another local time.

kaushiknsolanki — Tue, 28 Nov 2017 10:42:30 GMT

Hi,

Check this link.

Regards,

Kaushik Solanki

Anonymous — Tue, 28 Nov 2017 10:45:23 GMT

I explicitly say that, this is not something I am looking for.

Converts a UTC or GMT timestamp to local time as a dual value.

This mean that it convert UTC to something else. I need to get UTC. This is my question.

kaushiknsolanki — Tue, 28 Nov 2017 10:50:14 GMT

Hi,

You can still use that function. Check below link.

Regards,

Kaushik Solanki

Anonymous — Tue, 28 Nov 2017 11:26:18 GMT

Do I understand that I should use ConvertToLocalTime with GMT-2.00 time zone?.

This could be problem, because of the daylight saving time.