title: How to get the date and time from timestamp in PostgreSQL select query?
body: <p>How to get the date and time only up to minutes, not seconds, from timestamp in PostgreSQL. I need date as well as time.</p>
  
  <p>For example:</p>
  
  <pre><code>2000-12-16 12:21:13-05 
  </code></pre>
  
  <p>From this I need</p>
  
  <pre><code>2000-12-16 12:21 (no seconds and milliseconds only date and time in hours and minutes)
  </code></pre>
  
  <p>From a timestamp with time zone field, say <code>update_time</code>, how do I get date as well as time like above using PostgreSQL select query.</p>
  
  <p>Please help me.</p>