title: Converting XML date (ISO-8601) into timestamp in Oracle
body: <p>Could you please help me in converting date time of format from "2015-02-23T16:26:41.485+05:30" to "23-FEB-15 16.26.41.000000000 AM" in Oracle.</p>
  
  <p>I have an ISO-8601 date string in variable: </p>
  
  <pre><code>START_TIME='2015-02-23T16:26:41.485+05:30'
  </code></pre>
  
  <p>When I use</p>
  
  <pre><code>to_timestamp(START_TIME,'yyyy-mm-dd"T"hh24:mi:ss.ff3')
  </code></pre>
  
  <p>I get: </p>
  
  <pre><code>Error report:
  ORA-01830: date format picture ends before converting entire input string
  ORA-06512: at line 55
  01830. 00000 -  "date format picture ends before converting entire input string"
  *Cause:    
  *Action:
  </code></pre>