title: PostgreSQL convert date with timezone to a timestamp
body: <p>I have date stored in format <code>DD/MM/YYYY HH24:MI TZ</code> (datetime with timezone) in my psql database. I need to convert this date to a timestamp.</p>
  
  <p>I tried to_timestamp() but it is not working with timezone.</p>
  
  <pre><code>ERROR:  "TZ"/"tz"/"OF" format patterns are not supported in to_date
  </code></pre>
  
  <p>I tried ::timestamptz but it consider date to be in format of <code>MM/DD/YYYY HH24:MI TZ</code></p>
  
  <pre><code>ERROR:  date/time field value out of range
  </code></pre>
  
  <p>Is there any way to convert the format from <code>DD/MM/YYYY HH24:MI TZ</code> to <code>MM/DD/YYYY HH24:MI TZ</code> or convert <code>DD/MM/YYYY HH24:MI TZ</code> to timestamp?</p>
  
  <p>e.g. "28/04/2017 13:00 +2:30"</p>