Oracle how to convert time in UTC to the local time (offset information is missing)
<p>I have a table which contains a date column. I think that the date in that column is saved in UTC.</p>

<p>I would like when the date is retrieved that it is printed in local time. That means when I call the date from Germany, the result should be something like this:</p>

<pre><code>2015-04-29 11:24:06 +0200UTC EUROPE/BERLIN
</code></pre>

<p>I tried the following sql: </p>

<pre><code>SELECT TO_CHAR(CAST(dateColum as  TIMESTAMP WITH LOCAL TIME ZONE), 'YYYY-MM-DD HH24:MI:SS TZR') from myTable;
</code></pre>

<p>the result looks like this: </p>

<pre><code>2015-04-29 11:24:06 EUROPE/BERLIN
</code></pre>

<p>+/- offset is missing.</p>

<p>Any idea?</p>