- SELECT TIME_TO_SEC(TIMEDIFF(‘12:01:00’, ‘12:00:00’)) diff;
- 运行结果如下:
- 查询cap_punchclocktimespan 表下开始时间(clockStartTime)与传入参数时间范围小于5分钟的数据
select
TIME_TO_SEC(TIMEDIFF(clockStartTime, '08:57:00')) ssss ,id
from
cap_punchclocktimespan
HAVING ssss < 300 and ssss > 0