mysql时间格式点分割,PHP：在mysql中分割时间戳值内的日期和时间

I have a field called "timestamp" in a database table which stores value in this format :- YYYY-MM-DD HH:MM:SS.

I would like to split apart and then fetch the date (YYYY-MM-DD) in a variable and also the time (HH:MM:SS) in another variable. Example:

$timestamp = "2012-10-19 18:19:56";

$get_date = "2012-10-19";

$get_time = "18:19:56";

I would be glad if anyone can help out with this using php.

解决方案

You could simply split the string by the space character using PHP's explode() function -

$timestamp = "2012-10-19 18:19:56";

$splitTimeStamp = explode(" ",$timestamp);

$date = $splitTimeStamp[0];

$time = $splitTimeStamp[1];

Another way of doing this would be this would be to use strtotime() combined with date()-

$date = date('Y-m-d',strtotime($timestamp));

$time = date('H:i:s',strtotime($timestamp));