EN (DE unten)
At what time are the posts created?
I was wondering at what time the posts are created on Hive. To find out, I look at the posts from the last 30 days (only posts, no comments).
SELECT
DATEPART(HOUR, created) AS Hour,
COUNT(*) AS NumberOfPosts
FROM Comments
WHERE created >= DATEADD(DAY, -30, GETDATE())
AND depth = 0
GROUP BY DATEPART(HOUR, created)
ORDER BY Hour;
Who would have thought? It's quite evenly distributed, which is certainly due to the fact that Hive is used internationally and not just locally.
DE
zu welcher Uhrzeit werden die Posts erstellt
Ich habe mich gefragt, zu welcher Uhrzeit werden die Posts auf Hive erstellt. Dafür schaue ich mir die Posts der letzten 30 Tage an (Nur Beiträge, keine Kommentare).
SELECT
DATEPART(HOUR, created) AS Stunde,
COUNT(*) AS AnzahlPosts
FROM Comments
WHERE created >= DATEADD(DAY, -30, GETDATE())
AND depth = 0
GROUP BY DATEPART(HOUR, created)
ORDER BY Stunde;
Wer hätte es gedacht? Es ist doch recht gleichmäßig verteilt, liegt sicherlich daran, das Hive ebne international genutzt wird und nicht nur örtlich begrenzt.
Congratulations @hive-coding! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)
Your next target is to reach 200 replies.
You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPCheck out our last posts: