ALTER TABLE `wp_posts` CHANGE `post_date` `post_date_old` int(11) NOT NULL ALTER TABLE `wp_posts` ADD `post_date` UNIXTIME NOT NULL UPDATE `wp_posts` SET `post_date`=FROM_DATETIME(post_date_old)