Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Unveils New Agentic Capabilities Across Analytics, Data Engineering, and Trust: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

ConvertToLocalTime: Change in QV11 to QV12

In the ConvertToLocalTime() function, there is a difference in DST (daylight savings) handling between QV10/11/12 and QV12.10.

QV11 applied DST processing to City placenames as well as placenames of the form "GMT-nn".  QV12.10 does not apply DST when "GMT-nn" or "UTC-nn" is used.  It can't be forced with the ignore_dst parameter either. I can't find anything in the doc or release notes on this change.

2017-11-03_9-38-32.png

2017-11-03_9-38-59.png

-Rob

Labels (2)
1 Solution

Accepted Solutions
rbecher
Partner - Master III
Partner - Master III

I know because of Halloween. I meant there are more countries in that timezone than the US and US just breaks the rule here. So this is not THE US timezone.

I think at least Jamaica is in same timezone but w/o DST now.

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

View solution in original post

5 Replies
rbecher
Partner - Master III
Partner - Master III

Actually, I think this is wrong for the US only but not for the whole timezone GMT-05:00 !

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

Ralf,

I think it's wrong for the US today because we are still on DST (we go off Sunday).  If you test this in Europe, it will appear correct because you are already off DST.

It will be "correct" for all of us on Monday morning

-Rob

rbecher
Partner - Master III
Partner - Master III

I know because of Halloween. I meant there are more countries in that timezone than the US and US just breaks the rule here. So this is not THE US timezone.

I think at least Jamaica is in same timezone but w/o DST now.

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
rbecher
Partner - Master III
Partner - Master III

So to me it's right than GMT-05:00 is just not specific enough..

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
Author

I understand what you are saying Ralf.  All locations in DST-nnnn are not observing DST for the same dates, if observing it at all. So the QV12 behavior is correct, QV11 was wrong in some cases.

So the doc should be updated to reflect that GMT-nnnn names do not consider DST.

-Rob