按日期范围内的天数分组结果

SELECT * FROM test WHERE 
timepacket BETWEEN '2014-02-16 00:00:00' AND '2014-02-19 00:00:00' 
AND shift = 1 
GROUP BY timepacket;

使用GROUP BY或 排序依据:

SELECT * FROM test WHERE (timepacket BETWEEN 2014-02-16 00:00:00 and 2014-02-19 00:00:00)
 AND (shift = 1) GROUP BY timepacket

即使您的查询也不太清楚,但根据我的理解,您希望根据日期进行订购,如果是,请使用以下查询-

SELECT * FROM test WHERE (timepacket BETWEEN 2014-02-16 00:00:00 and 2014-02-19 00:00:00) AND shift = 1 order by date(timepacket);