flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Countdown Hours
zakkisyed
Countdown Hours
Updated 2023-07-19
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
SELECT
FLOOR
(
DATEDIFF
(
'hour'
,
MAX
(
block_timestamp
)
,
TIMESTAMP
'2023-04-12 22:57:00'
)
)
AS
hours_left
FROM
ethereum
.
core
.
fact_transactions
;
Results
Run a query to Download Data