title: Oracle how to convert time in UTC to the local time (offset information is missing)
body: <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>