title: Convert all colums in the rows from date to timestamp MySQL
body: <p>I have a database with 13000 rows. Each row contains the column 'date' which is now in this format (example): <code>2012-09-01 17:53:28</code>, but I want them to be a TIMESTAMP.</p>
  
  <p>What query should I run to update all columns named 'date'  from date to timestamp on all rows?</p>
  
  <p>Thanks</p>