Convert UTC to Local Timezone in Oracle PL/SQL
<p>how to convert UTC to local time with Oracle PL/SQL? My data provider send me following: </p>

<pre><code>    &lt;EndDateTime&gt;"2016-09-26T08:00:00Z"&lt;/EndDateTime&gt;
</code></pre>

<p>and I would like to convert it to "Berlin" Time. I've searched here for an answer, but it is quite difficult to find the right answer. </p>