我试图从我的到达时间表中选择不是确切的到达时间,而是通过此查询选择-+ 2分钟:
SELECT route from arrivaltimes INNER JOIN stops
ON arrivaltimes.stop_id=stops.stop_id
WHERE weekday = ?
and time_format(arrivaltime,'%H:%i')= time_format(curtime() ,'%H:%i')
and name LIKE ?
如何选择+-2分钟?
如果字段到达时间是一个TIME
字段,则该方法应该起作用:
SELECT route
FROM arrivaltimes
INNER JOIN stops ON (arrivaltimes.stop_id = stops.stop_id)
WHERE
weekday = ?
AND arrivaltime >= curtime() - INTERVAL 2 MINUTE
AND arrivaltime <= curtime() + INTERVAL 2 MINUTE
AND name LIKE ?
或者,您可以使用BETWEEN运算符:
SELECT route
FROM arrivaltimes
INNER JOIN stops ON (arrivaltimes.stop_id = stops.stop_id)
WHERE
weekday = ?
AND arrivaltime BETWEEN curtime() - INTERVAL 2 MINUTE AND curtime() + INTERVAL 2 MINUTE
AND name LIKE ?
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句