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