title: PostgreSQL unable to parse string to date using to_date()
body: <p>I have a pretty standard date as a string that I need to parse to a date type:</p>
  
  <pre><code>"2016-06-01T23:34:25+00:00"
  </code></pre>
  
  <p>I'm using <code>'YYYY-MM-DDTHH24:MI:SS'</code> as the format mask and this query to try to get and parse the date:</p>
  
  <pre><code>SELECT to_date('last_updated_on', 'YYYY-MM-DDTHH24:MI:SS') 
  AS last_updated_on FROM locations 
  limit 1
  </code></pre>
  
  <p>What happens is I get this error:</p>
  
  <pre><code>ERROR: invalid value ":2" for "MI"
  SQL state: 22007
  Detail: Value must be an integer.
  </code></pre>
  
  <p>I've looked all over in the documentation and on SO trying to find out why this is happening, and I'm totally baffled.</p>
  
  <p>I'm using PostgreSQL 9.4</p>