How to convert MySQL time to UNIX timestamp using PHP?

Question

There are a lot of questions that ask about 'UNIX timestamp to MySQL time'. I needed the reversed way, yea... Any idea?

Answer 1

Use strtotime(..):

$timestamp = strtotime($mysqltime); echo date("Y-m-d H:i:s", $timestamp); 

Also check this out (to do it in MySQL way.)

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_unix-timestamp

Answer 2

You can mysql's UNIX_TIMESTAMP function directly from your query, here is an example:

SELECT UNIX_TIMESTAMP('2007-11-30 10:30:19'); 

Similarly, you can pass in the date/datetime field:

SELECT UNIX_TIMESTAMP(yourField);