title: Trim trailing spaces with PostgreSQL
body: <p>I have a column <code>eventDate</code> which contains trailing spaces. I am trying to remove them with the PostgreSQL function <code>TRIM()</code>. More specifically, I am running:</p>
  
  <pre><code>SELECT TRIM(both ' ' from eventDate) 
  FROM EventDates;
  </code></pre>
  
  <p>However, the trailing spaces don't go away. Furthermore, when I try and trim another character from the date (such as a number), it doesn't trim either. If I'm reading <a href="http://www.postgresql.org/docs/current/static/functions-string.html">the manual</a> correctly this should work. Any thoughts?</p>