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: 
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.

0 Replies