每小时获取每日数据 [英] Get daily data from hourly

问题描述

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



我尝试过：

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;

这篇关于每小时获取每日数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！