title: Convert rfc3339 string to timestamp with timezone
body: <p>Is there any way to properly convert a rfc3339 string in a <code>character varying</code> column to a <code>timestamp with timezone</code>?</p>
  
  <pre><code>Input: "2015-01-28T17:41:52Z"
  Expected output: "2015-01-28 17:41:52+00"
  Current output: "2015-01-28 17:41:52+01"
  </code></pre>
  
  <p>I tried the following</p>
  
  <pre><code>/* begin dummy data */
  WITH messages as (
      select 123 as id, '2015-01-28T17:41:52Z'::text as received
  )
  /* end dummy data */
  SELECT id, received, (to_timestamp(received, 'YYYY-MM-DDThh24:MI:SS')) as d
  FROM messages
  </code></pre>
  
  <p>Adding <code>TZ</code> or <code>tz</code> is not possible for input data and <code>OF</code> <a href="http://www.postgresql.org/docs/9.3/static/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABLE" rel="nofollow">is available in 9.4</a> but <a href="http://www.postgresql.org/docs/9.3/static/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABLE" rel="nofollow">not in 9.3</a>.</p>