title: Oracle SQL how to convert time zone string to date
body: <p>I have following <code>2015-06-17T00:00:00.000+05:00</code> string.
  I want to convert this string to Date using oracle sql.
  I tried lot of format mask but none works for me :</p>
  
  <pre><code>SELECT TO_DATE('2015-06-17T00:00:00.000+05:00','yyyy-mm-dd HH24:MI:SS TZR') FROM DUAL;
  </code></pre>
  
  <p>Any idea which format mask should i apply for above conversion.
  Also please note that i only need date information i.e <code>(mm-dd-yyyy)</code>. So its also ok if the conversion results in date information only (i.e skipping time information)</p>