title: Default timestamp format and fractional seconds
body: <p>I'm trying to format the timestamps in my Postgres database to a certain format:</p>
  
  <pre><code>YYYY-MM-DD HH24:MI:SS
  </code></pre>
  
  <p>By doing:</p>
  
  <pre><code>update myTable set tds = to_char(tds, 'YYYY-MM-DD HH24:MI:SS')::timestamp;
  </code></pre>
  
  <p>I managed to set all the previously stored <code>tds</code> to this format. However, any newly added entry goes back to: <code>YYYY-MM-DD HH24:MI:SS.MS</code> since the default is set to <code>now()</code>.</p>
  
  <p>How do I change this so that newly added entries also have the format: <code>YYYY-MM-DD HH24:MI:SS</code>?</p>