Convert MySQL date to UNIX timestamp
< ?php
// from MySQL to UNIX timestamp
function convert_datetime($str)
{
list($date, $time) = explode(' ', $str);
list($year, $month, $day) = explode('-', $date);
list($hour, $minute, $second) = explode(':', $time);
$timestamp = mktime($hour, $minute, $second, $month, $day, $year);
return $timestamp;
}
?>
Categories: php_mysql