title: Postgres- have to_timestamp() ignore/not read a specific character in middle of date/time string
body: <p>I have raw text column with values like '2012-07-26T10:33:34' and '2012-07-26T10:56:16'.  In Java using Joda-Time I can easily convert this to/from a date by calling </p>
  
  <p><code>new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss")</code>.</p>
  
  <p>In Postgres how would I ignore this 'T' character in the middle?</p>
  
  <p>I have tried <code>'YYYY-MM-DD\THH:mm:ss'</code> but get the error </p>
  
  <p><em>> ERROR: failed to find conversion function from unknown to text</em></p>