title: Oracle Convert TIMESTAMP with Timezone to DATE
body: <p>I have DB with timezone <code>+04:00 (Europe/Moscow)</code> and need to convert a string in format <code>YYYY-MM-DD"T"HH24:MI:SSTZH:TZM</code> to <code>DATE</code> data type in Oracle 11g.</p>
  
  <p>In other words, I have a string <code>2013-11-08T10:11:31+02:00</code> and I want to convert it to <code>DATE</code> data type (in local DB timezone <code>+04:00 (Europe/Moscow)</code>).</p>
  
  <p>For string <code>2013-11-08T10:11:31+02:00</code> my desired transformation should return <code>DATE</code> data type with date <code>2013-11-08 12:11:31</code> (i.e. with local timezone transformation of time to <code>+04:00 (Europe/Moscow)</code>). Timezone of string may be different and <code>+02:00</code> in string above is just example.</p>
  
  <p>I tried to do this with <code>TIMESTAMP</code> data type, but no success with time zone transformation.</p>