4 Replies Latest reply: Nov 28, 2017 6:26 AM by Marko Zadravec RSS

    Convert timestamp with timezone to UTC

    Marko Zadravec

      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.