每小时获取每日数据

本文介绍了每小时获取每日数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有查询返回每小时数据。但是我希望从这个查询中获取每日数据，因此每天的所有小时数据都将平均为每日数据。 我尝试过：

I have query which returns hourly data. But I want to get daily data from this query, so all the hourly data per day would be averaged to daily data. What I have tried:

declare @Days int set @Days = -1 select dateadd(hour,datepart(hour,Timestamp),cast(CAST((Timestamp) as date) as datetime)) as [Time] ,[Value] from [Employee] where dateadd(hour,datepart(hour,Timestamp),cast(CAST((Timestamp) as date) as datetime)) >= CONVERT(date, DATEADD(DAY, @Days, GETDATE()))

推荐答案

DECLARE @Days int = -1; SELECT CAST(Timestamp AS date) AS date , AVG(Value) AS Value FROM [Employee] WHERE Timestamp >= DATEADD(day, @Days, CAST(GETDATE() AS date)) GROUP BY CAST(Timestamp AS date) ORDER BY date;