title: Convert varchar to timestamp on PostgreSQL: ERROR: "TZ"/"tz" not supported
body: <p>I have the following problem. I work on converting timestamps stored in a varchar column:</p>
  
  <pre><code>|    MyTimestamp               |
  ---------------------------------
  |"Thu May 14 00:00:00 CEST 2009"|
  |"Fri Aug 31 00:00:00 CEST 2007"|
  </code></pre>
  
  <p>with the <a href="http://developer.postgresql.org/pgdocs/postgres/functions-formatting.html" rel="nofollow">to_timestamp</a> function:</p>
  
  <pre><code> select 
      to_timestamp(myTimestamp, 'Dy Mon DD HH24:MI:SS TZ YYYY'
   FROM 
      my_table
  </code></pre>
  
  <p>but I keep getting: </p>
  
  <pre><code>ERROR:  "TZ"/"tz" not supported
  
  ********** Error **********
  
  ERROR: "TZ"/"tz" not supported
  SQL state: 0A000
  </code></pre>
  
  <p>I wonder what I did wrong, is there a better way to convert a varchar to timestamp? Does not PostgreSQL support TZ/tz?</p>