SELECT * FROM test WHERE DATE_FORMAT(sumtime,'%Y-%m-%d')>='2014-08-01' AND DATE_FORMAT(sumtime,'%Y-%m-%d')=18 AND DATE_FORMAT(sumtime,'%H')
mysql查询某段时间段中每一天的数据
select month,ifnull(sum(汇总字段),0) from 表 where 条件 group by month;
满意请采纳。2014-08-25
SELECT * FROM test WHERE DATE_FORMAT(sumtime,'%Y-%m-%d')>='2014-08-01' AND DATE_FORMAT(sumtime,'%Y-%m-%d')<='2014-08-20' AND DATE_FORMAT(sumtime,'%H')>=18 AND DATE_FORMAT(sumtime,'%H')<=202014-08-25
SELECT * WHERE sumtime >1 AND sumtime <202014-08-25
