0 Replies Latest reply: Sep 27, 2016 5:45 AM by Jordi Queralt RSS

    CONVERTTOLOCALTIME issue

    Jordi Queralt

      Hi,

      could someone tell me how this method it supposes to work?

      If I am converting to UTC time a UTC time, shouldn't it be returning the same time? It is not, at least for me. (GMT either).

      UTC is not affected by DST either, thought it seems that if set the ignore_dst to true, it is returning correctly same time thought other timezones are then not working fine.

       

      I've prepared a little load script snippet to highlight the problem:

       

      test:

      LOAD 

           TIMESTAMP(CONVERTTOLOCALTIME(UTC(),'UTC'), 'YYYY-MM-DD hh:mm:ss') AS utc_converted_timestamp,

           TIMESTAMP(UTC(), 'YYYY-MM-DD hh:mm:ss') AS utc_timestamp

           AUTOGENERATE(1);

       

      utc_converted_timestamp and utc_timestamp are not the same.

      Note: I have used timestamp() function for displaying purposes.

      And please, don't ask me why I am doing this useless conversion as this is part of a complex load script, just simplified it to show the problem.

       

      Qlikview 11.20 SR15

      Thanks.