title: Using toChar to convert W3C XML Schema xs:dateTime type format to dd-mm-yy hh:mm:ss
body: <p>I'm trying to convert an XML Schema xs:dateTime formatted date to a more readable format using <code>to_char</code>.</p>
  
  <p>I've tried:</p>
  
  <pre><code>select to_char('2013-08-16T09:55:02+02:00', 'dd-mm-yyyy hh:mm:ss') 
    from dual;
  </code></pre>
  
  <p>but this fails.</p>
  
  <p>Any clues on how to do this?</p>