Datetime To Unix timestamp

Question

Is there anyone sitting on a PHP function to convert a date of format 0000-00-00 00:00:00(datetimesql) to unix timestamp?

Thanks in advance.

Answer 1

Use strptime() to parse the time and turn it into a structured array.

Then pass the results of that into the mktime() function to get a UNIX timestamp.

Answer 2

Try strptime.

Answer 3

Another option as you have tagged this question with SQL: the MySQL functions FROM_UNIXTIME and UNIX_TIMESTAMP -> MySQL manual

SELECT UNIX_TIMESTAMP(datetime_column) FROM table

This usually is faster than a PHP function call.

Answer 4

i think ill use http://php.net/strtotime
lol

Answer 5

@bartek - As you noted, PHP's strtotime function is perfect for this. It can handle most common date formats, including strings like "tomorrow" or "+5 months".

Answer 6

Encapusulating wvanbergen's solution into a function (for your convenience)

//Convert SQL datetime to unixtime -- by johnboiles
function datetimeToUnixtime($datetime){
    $result = mysql_query("select unix_timestamp('$datetime')");
    $unixtime = mysql_fetch_array($result);
    return $unixtime[0];
}