title: UNIX Timestamp to MySQL DATETIME
body: <p>I have a table with statistics and a field named <code>time</code> with Unix Timestamps.</p>
  
  <p>There are about 200 rows in the table, but I would like to change the Unix timestamps to MySQL DATETIME without losing the current rows. The current table:</p>
  
  <pre><code>CREATE TABLE `stats` (
      `id` int(11) unsigned NOT NULL auto_increment,
      `time` int(11) NOT NULL,
      `domain` varchar(40) NOT NULL,
      `ip` varchar(20) NOT NULL,
      `user_agent` varchar(255) NOT NULL,
      `domain_id` int(11) NOT NULL,
      PRIMARY KEY  (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>So the <code>time</code> (INT) should be a DATETIME field.</p>
  
  <p>How can I update the Unix Timestamp to MySQL's DATETIME?</p>