select convert(varchar(10),dateadd(hh,8,date),120) date from tb group by convert(varchar(10),dateadd(hh,8,date),120)
select convert(varchar(10),dateadd(hh,8,date),120) date,sum(quantity) qty from tb group by convert(varchar(10),dateadd(hh,8,date),120)汇总每天8点到第二天八点的数量,日期显示为这天的年-月-日。
declare ndatetime as datetime set ndatetime='2012-02-09 10:00:00' select convert(varchar(10),ndatetime,120)
select convert(varchar(10),dateadd(hh,8,date),120) date
from tb
group by convert(varchar(10),dateadd(hh,8,date),120)
select convert(varchar(10),dateadd(hh,8,date),120) date,sum(quantity) qty
from tb
group by convert(varchar(10),dateadd(hh,8,date),120)汇总每天8点到第二天八点的数量,日期显示为这天的年-月-日。
set ndatetime='2012-02-09 10:00:00'
select convert(varchar(10),ndatetime,120)