title: Change timezone component of TIMESTAMP WITH TIMEZONE in Oracle
body: <p>I have some data that is stored in a <code>TIMESTAMP(6) WITH TIMEZONE</code> column in Oracle, but it is stored in the wrong timezone. By convention, all timestamps in the DB must be stored in UTC, but this data was incorrectly persisted as EDT. The actual values are equivalent to the correct UTC value; the problem is simply that it is stored as <code>19-JUN-12 12.20.42.000000000 PM AMERICA/NEW_YORK</code> when instead it should be <code>19-JUN-12 16.20.42.000000000 PM UTC</code>. Is there <em>any</em> way in Oracle to change this?</p>