Posting users and posts by hour of week, GMT

1

Please login or register to vote for this query.

(click on this box to dismiss)

Worldbuilding

Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings

select
    (datepart(weekday, creationdate)-1) * 24
    + datepart(hour, creationdate) as hour_of_week_GMT
  , count (distinct owneruserid) as PostingUsers
  , count (*) as NumPosts
from posts p
where datediff(d, creationdate, getdate()) <= ##DaysOfHistory## 
group by (datepart(weekday, creationdate)-1) * 24
    + datepart(hour, creationdate)
order by (datepart(weekday, creationdate)-1) * 24
    + datepart(hour, creationdate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results