title: Oracle Date datatype, transformed to 'YYYY-MM-DD HH24:MI:SS TMZ' through SQL
body: <p>I have an application that uploads to an Oracle Data datatype column via:</p>
  
  <pre><code>TO_TIMESTAMP_TZ('2012-10-09 1:10:21 CST','YYYY-MM-DD HH24:MI:SS TZR')
  </code></pre>
  
  <p>I now need to pull the following format and timezone from this Data column:
  'YYYY-MM-DD HH24:MI:SS CDT'</p>
  
  <p>Note: that the date is uploaded in CST but needs to be returned in CDT.</p>
  
  <p>I have Google'd but have only found following for Date datatypes:</p>
  
  <pre><code>SELECT dateColumn From dateTable;
  09-NOV-12
  
  SELECT TO_CHAR(dateColumn,'YYYY-MM-DD HH24:MI:SS') From dateTable;
  2012-10-09 1:10:21
  </code></pre>
  
  <p>I have tried the following also: </p>
  
  <pre><code>TO_TIMESTAMP_TZ(dateColumn,'YYYY-MM-DD HH24:MI:SS CDT')
  data format not recognized
  
  TO_TIMESTAMP_TZ(CRTE_DT,'YYYY-MM-DD HH24:MI:SS TZH:TZM')
  09-NOV-12 1:10:21 AM +01:00
  don't understand why this does not come back as YYYY-MM-DD?
  </code></pre>
  
  <p>How can I solve this problem?</p>