sql - 按日期选择数据并汇总数据 - SQL Server 2005

Question

我来自 MySQL，并尝试在 SQL Server 2005 上编写 T-SQL，我发现它完全不同。

这是我想做的(使用 MySQL)

select sum(datapoint) as sum, date(mytimestamp) as date
from datalog
where datapoint = '27'
group by date

即获取按日期汇总和分组的数据列表。

Answer 1

<罢工>

<罢工>

sql server 2008被标记时的回答

select sum(datapoint) as [sum], CAST(mytimestamp AS DATE) as [date]
from datalog
where datapoint = '27'
group by CAST(mytimestamp AS DATE)

<罢工>

对于 SQL Server 2005

SELECT   CONVERT(VARCHAR(11), timestamp, 111) DATE, 
         SUM(datapoint) totalDatapoint
FROM     table1
GROUP BY CONVERT(VARCHAR(11), timestamp, 111)
ORDER BY DATE ASC

SQLFiddle Demo