flipside

    Maximum between block time
    Stin00Maximum between block time
    Updated 2022-07-26
    --darvishi
    SELECT

    Max(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as Max_between_block_time

    FROM polygon.core.fact_blocks a
    JOIN polygon.core.fact_blocks b
    on a.BLOCK_NUMBER = b.BLOCK_NUMBER - 1

    Run a query to Download Data