title: Postgres Datetime Replace regex
body: <p>I've gotten as far as possible alone.</p>
  
  <p>I need to replace the time within a datetime stamp in postgres.</p>
  
  <p>This:</p>
  
  <p>2015-11-20 08:00:00</p>
  
  <p>Needs to be this:</p>
  
  <p>2015-11-20 09:00:00</p>
  
  <p>but for every day of the year (only the time changes)</p>
  
  <p>this is what I have so far. (am i even close?)</p>
  
  <pre><code>UPDATE
     events 
  SET
     starttime = regexp_replace(starttime,
     E’[0-9]{4}-[0-9]{1,2}-[0-9]{1,2} [0-0]{1}[8-8]{1}:[0-0]{1,2}:[0-0]{1,2}’,
     E’[0-9]{4}-[0-9]{1,2}-[0-9]{1,2} [0-0]{1}[9-9]{1}:[0-0]{1,2}:[0-0]{1,2}’,‘g’)            
  WHERE
     account_id = 9           
     AND starttime ~ E’[0-9]{4}-[0-9]{1,2}-[0-9]{1,2} [0-0]{1}[8-8]{1}:[0-0]{1,2}:[0-0]{1,2}’;
  </code></pre>