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

[Anonymous]

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

[Anonymous]

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 

[TRF]

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/