PHP: splitting the date and time within a timestamp value in mysql
34,613
Solution 1
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));
Solution 2
Thats simple, use explode, try this below it wil work
$new_time = explode(" ",$timestamp);
$get_date = $new_time[0];
$get_time = $new_time[1];
Solution 3
You could use the explode
function; plus list
function could make your code slightly shorter:
list($get_date, $get_time) = explode(" ", "2012-10-19 18:19:56");
var_dump($get_date, $get_time);
Solution 4
$timestamp = "2012-10-19 18:19:56";
$splits = explode(" ",$timestamp);
$get_date = $splits[0];
$get_time = $splits[1];
Author by
Sms
Updated on September 22, 2020Comments
-
Sms over 3 years
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.
-
Duncanmoo about 2 yearsPlease consider adding some text about what you did in the fiddle, also make sure that your link is displaying correctly, because this link is broken