I want to convert MySQL Time data type using PHP and Javascript. I know it can be done using FORMAT_TIME of MySql, but I would like to do the same with php. The Time format is hh:mm:ss by default and I would like to convert it to hh:mm.
3
-
1php.net/manual/en/function.date-create-from-format.phpMarc B– Marc B2012-04-10 16:39:03 +00:00Commented Apr 10, 2012 at 16:39
-
Do You use a Datetime Field? or only Date? or a Timestamp?René Höhle– René Höhle2012-04-10 16:39:20 +00:00Commented Apr 10, 2012 at 16:39
-
Where does the javascript fit in?jeroen– jeroen2012-04-10 16:41:41 +00:00Commented Apr 10, 2012 at 16:41
Add a comment
|
3 Answers
Just feed the date into the following function(s):
<?php echo date("h:i", strtotime($date)); ?>
1 Comment
maniak
thanks, I like this solution! Can be integrated easily where I display the output
//any date is ok, we care only about the hours and minutes
// $your_date is what comes from db in format hh:mm:ss
$date = new DateTime('2000-01-01 '.$your_date);
echo $date->format('H:i');
Comments
I think you could create a DateTime object and then use format("h:i") to get the desired output
