title: MYSQL Datetime, remove seconds
body: <p>I've been attempting to do this for quite sometime. </p>
  
  <p>I have a program which periodically writes rows to a table.<br>
  (table1)
  ID  Date Text Number   </p>
  
  <p>The Date column is in format yyyy-mm-dd hh:mm:ss ("2013-08-03 06:26:27") </p>
  
  <p>The script which reads the data matches it to another set of data with the date in the same format except that the seconds are exactly 0.  </p>
  
  <p>"2013-08-03 06:26:00"</p>
  
  <p>I need to change the Date data column in (Table 1) so that the seconds column is exactly zero. Currently it is just random values. </p>
  
  <p>I have changed it on script level so that it writes the data to the MYSQL table so that the seconds is 0. However I have a lot of existing data which I can not loose which does not have the seconds at 0. </p>