Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert timestamp with timezone to UTC

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 fieldActual UTC time (not in DB)
2017-08-22 01:08:56+022017-08-21 23:08:56
2017-08-22 14:29:10+022017-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.

4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Check this link.

converttolocaltime ‒ QlikView

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

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.