In the mysql database I'm currently working on, there's a DATETIME field which has the format 0000-00-00 00:00:00. How can I convert that to have the same format as time(), so I can do calculations with the DATETIME field using the time()-function?
UNIX_TIMESTAMP, as described here.