mysql时间比较

 select * from SY_ZGRD where SHZT_DM = '' and ZXBZ ='Y' AND SQRQ >= '2017-04-28 00:00:00' AND SQRQ <= '2017-04-28 23:59:59';

 select * from SY_ZGRD where SHZT_DM = '' and ZXBZ ='Y' AND SQRQ >= '2017-04-28 00:00:00' AND SQRQ <= '2017-04-28 23:59:59' and zgrs >=1;