title: How to remove the tail from timestamp field?
body: <p>I have a <code>TIMESTAMP WITHOUT TIME ZONE</code> field</p>
  
  <p>when I do:</p>
  
  <pre><code>select datex
  from A 
  </code></pre>
  
  <p>it shows me <code>datex</code> as: <code>2015-09-16 10:59:59.073629</code></p>
  
  <p>how do I modify it to be <code>2015-09-16 10:59:59</code>?</p>
  
  <p>I don't need the tail after the seconds.</p>
  
  <p>I read this <a href="http://www.postgresql.org/docs/9.1/static/functions-datetime.html" rel="nofollow">http://www.postgresql.org/docs/9.1/static/functions-datetime.html</a> but coldn't find a match.</p>