降采样与升采样

SQL Server 中的时间序列分析

Maham Faisal Khan

Senior Data Science Content Developer

自然状态下的数据

SELECT
    SomeDate
FROM dbo.SomeTable

SELECT
    CAST(SomeDate AS DATE) AS SomeDate
FROM dbo.SomeTable

SELECT
    DATEADD(HOUR, DATEDIFF(HOUR, 0, SomeDate), 0) AS SomeDate
FROM dbo.SomeTable

DATEDIFF(HOUR, 0, '2019-08-11 06:21:16') = 1,048,470

DATEADD(HOUR, 1048470, 0) = 2019-08-11 06:00:00

SQL Server 中的时间序列分析