title: Querying Oracle TIMESTAMP WITH TIMEZONE
body: <p>I have a column in an Oracle DB table that is of type <code>TIMESTAMP(6) WITH TIME ZONE</code>. There are data rows with data from different timezones, some UTC, some in other timezone offsets.</p>
  
  <p>Is there a way I can query the Oracle table so that the results always come back as UTC, with the appropriate time shifting being done? Is there something that can be done on the query itself, or perhaps altering the session somehow? I've tried altering the session timezone to Utc, but this seems to only impact the CURRENT_TIMESTAMP value.</p>
  
  <pre><code>ALTER SESSION SET TIME_ZONE = 'Utc'
  </code></pre>
  
  <p>For example, if a value was stored as:</p>
  
  <pre><code>21-JAN-10 03.28.38.635000000 PM -05:00
  </code></pre>
  
  <p>the query would come back as</p>
  
  <pre><code>21-JAN-10 08.28.38.635000000 PM Utc
  </code></pre>
  
  <p>Example table definition</p>
  
  <pre><code>CREATE TABLE "MyDb"."Books"
    (
      "GUID" RAW(32) DEFAULT SYS_GUID(),
       "DATE_CREATED" TIMESTAMP (6) WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
  );
  </code></pre>