After much research and trial and error, I find myself a bit frustrated. I am on the right path, but can't get the queries quite right. Any assistance would be greatly appreciated.
I know I need to convert the database field type DATETIME to UNIXTIME. I figured out how to display the whole field in UNIXTIME with the query below, but it does not permanently convert or save it.
Code:
SELECT UNIX_TIMESTAMP(`post_date`) FROM `wp_posts`
I also tried this (total experiment... don't laugh ) with no luck...
Code:
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)
01-08-2012, 07:02 AM
) with no luck...
Threaded Mode