降採樣與升採樣資料

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 的時間序列分析