Active Times

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gets the times which a user has been active

Game Development Meta

Q&A about the site for professional and independent game developers

-- Active Times
-- Gets the times which a user has been active

with hours as 
(
select datepart(hh, creationdate) as CC from posts where owneruserid = ##UserId##
union all
select datepart(hh, creationdate) as CC from comments where userid = ##UserId##
)

select CC from hours
order by CC

Enter Parameters

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