Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

CONVERTTOLOCALTIME issue

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.

Community Browser