title: postgresql - NOW() but less specific
body: <p>When I use SELECT NOW(); I'll get an output like this:</p>
  
  <pre><code>          now              
  -------------------------------
  2019-09-09 18:55:38.794006-05
  (1 row)
  </code></pre>
  
  <p>I want it like this:</p>
  
  <pre><code>          now              
  -------------------
  2019-09-09 18:55:38
  (1 row)
  </code></pre>
  
  <p>How do I make NOW() round up/down accordingly? I tried SELECT NOW()::timestamptz(0); but it keeps adding -05 to the end of the time :(</p>