Downsampling e upsampling dei dati

Analisi delle serie temporali in SQL Server

Maham Faisal Khan

Senior Data Science Content Developer

Dati in natura

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

Analisi delle serie temporali in SQL Server