Convert timestamp with timezone to UTC

[Anonymous]

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]

Hi,

Check this link.

converttolocaltime ‒ QlikView

Regards,

Kaushik Solanki

[Anonymous]

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

converttolocaltime - script and chart function

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]

Hi,

You can still use that function. Check below link.

how to convert a local time to utc time when I have the time zone?

Convert Local Time to UTC with Daylight Saving ... | Qlik Community

Regards,

Kaushik Solanki

[Anonymous]

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

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

Convert Local Time to UTC with Daylight Saving ... | Qlik Community is not answered bebause this.