Convert mysql DATETIME column to epoch seconds

You can use :

SELECT UNIX_TIMESTAMP(yourfield) FROM yourtable;

And for UPDATE, the invers function is : FROM_UNIXTIME(...)

CodeHunter