group by 与datediff问题

Question

数据库原始记录如图。

查询近一周的数据
select convert(varchar(19),DATEADD(hh,DATEDIFF(hh,0,TM),0),120) as createTime ,
convert(decimal(18,1),sum(INTV)) as drp
from ST_PPTN_R
where TM > #startTime# and #endTime# > TM and STCD = #stationNum# and
datepart(hh,TM) = '07' and datepart(mi,TM) = '55'
group by DATEDIFF(hh,0,TM)
ORDER BY DATEDIFF(hh,0,TM) desc

    结果如下

把分钟给去掉了。留的整点。

请教如何解决？

Answer 1

https://blog.csdn.net/lbh199466/article/details/100022693