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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert date/time from UTC to Local time based on country code or Time Zone

Hello, 

I have flights departure time that are stored in Oracle Database in UTC date & time.

I have a table with airport code, associated country and associated time zone.

Do you know a solution to convert date and time from UTC to Local based on available information ?

 

I can read on the community that some manage similar issue having the time difference between local & UTC ... I do not have such information ... 

 

Difference between UTC time and Local time is influenced by TimeZone, but also by time change Summer/Winter in some countries.

 

All ideas are welcome.

regards

 

Labels (3)
11 Replies
Anonymous
Not applicable
Author

HI I am trying to implement your idea but got below error while modify the pattern from source ,could you please help me in this 0683p000009M60o.png0683p000009M60t.png0683p000009M60y.png

TRF
Champion II
Champion II

2 things to be checked:

  1. input date is expected to be formatted as "yyyy-MM-ddTHH:mm:ssZ"
  2. timezone must be a valid one (from a Java point of view) such as  https://garygregory.wordpress.com/2013/06/18/what-are-the-java-timezone-ids/