分天小时段按小时段汇总数据

最新推荐文章于 2019-04-16 13:53:19 发布

a385833253

最新推荐文章于 2019-04-16 13:53:19 发布

阅读量765

点赞数

分类专栏： Microsoft SQL Server

本文链接：https://blog.csdn.net/a385833253/article/details/7593936

版权

Microsoft SQL Server 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

分天小时段汇总数据
select (cast(convert(varchar(100),dtime,23) as varchar(10))+':'+(case when len(cast(datepart(hour,convert(datetime,dtime))as varchar(4)))<2
then '0'+cast(datepart(hour,convert(datetime,dtime))as varchar(4))
else cast(datepart(hour,convert(datetime,dtime))as varchar(4)) end)as gtime,
count(*) as number from oplog where dtime between '2011-02-03 12:13:000' and '2011-08-03 12:13:000'
group by (cast(convert(varchar(100),dtime,23) as varchar(10))+':'+(case when len(cast(datepart(hour,convert(datetime,dtime))as varchar(4)))<2
then '0'+cast(datepart(hour,convert(datetime,dtime))as varchar(4))
else cast(datepart(hour,convert(datetime,dtime))as varchar(4)) end) order by gtime asc

统计一段时间内各小时段数据

select (case when len(cast(datepart(hour,convert(datetime,dtime))as varchar(4)))<2
then '0'+cast(datepart(hour,convert(datetime,dtime))as varchar(4))
else cast(datepart(hour,convert(datetime,dtime))as varchar(4)) end) as gtime,
count(*) as number from oplog where dtime between '2012-1-17' and '2012-5-17'
group by (case when len(cast(datepart(hour,convert(datetime,dtime))as varchar(4)))<2
then '0'+cast(datepart(hour,convert(datetime,dtime))as varchar(4))
else cast(datepart(hour,convert(datetime,dtime))as varchar(4)) end)
order by gtime asc