title: PostgreSQL: different output for timestamp without time zone depending on client
body: <p>I'm puzzled by my PostgreSQL database returning different results for a <code>timestamp(0) without time zone</code> field. Let's say I have a table <code>t</code></p>
  
  <pre><code>create table t (
      x timestamp(0) without time zone
  );
  insert into t select now();
  </code></pre>
  
  <p>Now when I run <code>select * from t</code> from different clients, I get different outputs.</p>
  
  <ul>
  <li><p><strong>PSQL:</strong> <code>2014-04-06 10:22:57</code></p></li>
  <li><p><strong>JDBC:</strong> <code>2014-04-06 10:22:57:000</code> <br> <em>(driver postgresql-9.3-1101.jdbc4.jar run through the <a href="http://eclipsesql.sourceforge.net/" rel="nofollow">SQLExplorer eclipse plugin</a>)</em></p></li>
  <li><p><strong>node-pg:</strong> <code>Sun Apr 06 2014 10:22:57 GMT+0200 (CEST)</code></p></li>
  </ul>
  
  <p>Of the three, only PSQL is the output I expected (and require). Why is this happening, and how can I fix it without having to explicitly cast in the query?</p>