CONVERTTOLOCALTIME issue

Tue, 27 Sep 2016 09:45:22 GMT

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.

topic CONVERTTOLOCALTIME issue in QlikView

CONVERTTOLOCALTIME issue