求按 每天的8：30到 次日的 8：30 分统计语句

Question

表table1
LotNo    isFlaw    checkTime  a          1        2009-4-2 6:01:38
b          0        2009-4-3 6:01:38
c          0        2009-4-5 18:01:38
a          0        2009-4-3 16:01:38
求个 解决方法

Answer 1

SELECT
  CONVERT(VARCHAR(10),DATEADD(MI,510,checkTime),120) as checkTime,
  count(1) as cnt
from
  table1
group by
  CONVERT(VARCHAR(10),DATEADD(MI,510,checkTime),120)

Answer 2

select * from table1
where checkTime between DATEADD(dd,-1, CONVERT(datetime,Convert(varchar(11),GETDATE(),120) +'8:30:00'))
and CONVERT(datetime,Convert(varchar(11),GETDATE(),120) +'8:30:00')

Answer 3

group by   convert(char(10), 
                    case when convert(char(05),checktime,108)>'08:30' 
                    then dateadd(day,1,checktime)
                     else checktime end, 
                   120)

Answer 4

group by   convert(char(10), 
                    case when convert(char(5),checktime,108)>'08:30' 
                    then dateadd(day,1,checktime)
                     else checktime end, 
                   120)UP,昨天刚写了个