$d = new datetime(date('H:i:s', strtotime('2014-09-30 23:21:55')));
$t = $d->diff(new datetime('18:00:0'));
echo $t->format('%H:%I:%S ');
echo $t->h * 60 + $t->i + $t->s / 60;05:21:55 321.91666666667
$t = $d->diff(new datetime('18:00:0'));
echo $t->format('%H:%I:%S ');
echo $t->h * 60 + $t->i + $t->s / 60;05:21:55 321.91666666667
kq.kq_time的值为2014-09-30 23:21:55
kq_c.am_on的值为18:00怎样使下面的MYSQL语句成立?
$sql_where .=" and DATE_FORMAT(kq.kq_time,'%H:%i')>kq_c.am_on";