PHP将mysql查询字符串转换为mm:ss时间格式


PHP convert mysql query string to mm:ss time format

我试图了解如何获得两个mysql varchar字符串之间的差异,它们的格式为mm:ss,其中m代表分钟,s代表秒。例如。

$a = 13:20;
$b = 13:00;

我使用什么功能才能使

 $a - $b =  00:20 ?
$a = strtotime('13:20');
$b = strtotime('13:00');
echo "The time difference between 13:20 and 13:00 is : "  . ($a - $b);
Gives me 
The time difference between 13:20 and 13:00 is : 1200
Kindly take note of my original format. mm:ss

使用strtotime()

试试这个。。。

$time1 = explode(':', '13:20');
$time2 = explode(':', '13:00');
$a = 00 . ':' . $time1[0] . ':' . $time1[1];
$b = 00 . ':' . $time2[0] . ':' . $time2[1];
echo "The time difference between 13:20 and 13:00 is : "  . (strtotime($a) - strtotime($b));