UNIX Timestamp to MySQL DATETIME
Remember to test it before using it for real, this is written from memory but should give you a good idea.
ALTER TABLE `stats` CHANGE `time` `unix_time` int(11) NOT NULL // rename the old columnALTER TABLE `stats` ADD `time` DATETIME NOT NULL // create the datetime columnUPDATE `stats` SET `time`=FROM_UNIXTIME(unix_time) // convert the dataALTER TABLE `stats` DROP `unix_time` // drop the old unix time column