mysql时间比较

 

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

 

posted @ 2017-05-05 15:16  Sunor  阅读(2095)  评论(0)  编辑  收藏  举报