title: Oracle TIMESTAMP WITH TIMEZONE named zone vs offset
body: <p>In oracle, is the named timezone always stored?</p>
  
  <p>I have been testing this column within our system, and in some places the timestamp is shown as:</p>
  
  <pre><code>26-FEB-09 11.36.25.390713 AM +13:00
  </code></pre>
  
  <p>but other times it's:</p>
  
  <pre><code>26-FEB-09 11.36.25.390713 AM Pacific/Auckland
  </code></pre>
  
  <p>If the value is being stored as the former, does that mean the actual timezone is not being stored?</p>
  
  <p>I worry because if a future date is stored with only an offset we might not be able to determine the actual time in the original timezone, because you can determine a offset from a timezone, but not vice versa.</p>
  
  <p>Thanks</p>