作者官方网站:http://www.wxl568.cn
按年月日查询
select count(1) from ts_clock_pdinfo T
WHERE date_format(T.start_date,'%Y-%m-%d ')=date_format(NOW(),'%Y-%m-%d ')
查询半小时内的数据
left join TM_CLOCK_ADDRESS A on A.ID = L.ADDRESS_ID
WHERE L.RESERVE2 is null AND L.CLOCK_TIME < DATE_ADD(NOW(), INTERVAL -30 MINUTE)
映射显示查询
if(A.CREATER='SYS_HRSS','yes','no') sysType