title: Remove milliseconds in a datetime field
body: <p>I converted a database from MS SQL to MySql using workbench. There is a table that has a column called <code>ActivityDate</code> (<code>datetime(6)</code>) . For some reason, when that column got converted it has a dot in the date like (<code>2013-05-03 11:20:20.420000</code>) .</p>
  
  <p>I want to remove the .420000 or whatever number is after the dot. I tried doing <code>SUBSTRING_INDEX(ActivityDate,'.',1)</code> but that didn't work, the last digits would just be <code>.000000</code> </p>
  
  <p>I also tried <code>UPDATE</code>alerts<code>.</code>activitylog<code>SET</code>ActivityDate<code>= date_format(ActivityDate, '%Y-%m-%d %H:%i')  WHERE</code>activitylog<code>.</code>ActivityLogID<code>= 5;</code></p>
  
  <p>And same issue... I get <code>.000000</code> at the end</p>
  
  <p>How can I do this?</p>