title: Use node-postgres to get Postgres "timestamp without timezone" in utc
body: <p>I've got some timestamps stored as the Postgres type <code>timestamp without time zone</code>.</p>
  
  <p>I'll use the timestamp <code>2013-12-20 20:45:27</code> as an example. I'm intending that this represent a UTC timestamp.</p>
  
  <p>In psql, if I run the query <code>SELECT start_time FROM table_name WHERE id = 1</code>, I get back that timestamp string, as expected: <code>2013-12-20 20:45:27</code>. </p>
  
  <p>However, if in my Node application, I use the node-postgres library to run that same query, I get back a timestamp in the local timezone: <code>Fri Dec 20 2013 20:45:27 GMT-0600 (CST)</code>. This is a Javascript date object, but it's already stored as that timezone. What I really want is a date object (or even just a string) that represents <code>2013-12-20 20:45:27 GMT+0000</code>. I already <strong>know</strong> that this time is UTC.</p>
  
  <p>I've tried setting the timezone param in my postgresql.conf file to: <code>timezone = 'UTC'</code>, with no difference in results.</p>
  
  <p>What am I doing wrong? </p>
  
  <p><strong>EDIT</strong></p>
  
  <p>The issue seems to be in this file: <a href="https://github.com/brianc/node-postgres/blob/master/lib/types/textParsers.js">https://github.com/brianc/node-postgres/blob/master/lib/types/textParsers.js</a></p>
  
  <p>If the date string returned from Postgres doesn't have a time-zone specified (i.e. <code>Z</code>, or <code>+06:30</code>, then it just constructs a JavaScript date object, which I believe will just include the local time zone. I either need to change my app to store time zones in the DB or override this converter.</p>