title: How to update a datetime field with timezone in postgresql
body: <p>As the question states i tried</p>
  
  <pre><code>UPDATE mytable set end_date="2015-07-17 22:00:00+00" WHERE id=8244;
  </code></pre>
  
  <p>But this does not work for obvious reasons, all the detail on the web is about searching for dates not updating them, especially when they have timezones</p>