title: ORA-01821: date format not recognized error for ISO 8601 date with local time
body: <p>I am trying to convert the date in SQL based on the parameter value in my Java code. However when the below query is executed I am getting error . Request you to help me in fixing this query.</p>
  
  <pre><code> SELECT TO_DATE ('2015-08-26T05:46:30.488+0100',
   'YYYY-MM-DD"T"hh24:mi:ss.sTZH:TZM')
    FROM DUAL
    *
  Error at line 2
  ORA-01821: date format not recognized
  </code></pre>
  
  <p>Date and Time format info:</p>
  
  <p><a href="http://www.w3.org/TR/NOTE-datetime" rel="noreferrer">http://www.w3.org/TR/NOTE-datetime</a></p>