0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select eomonth(CreationDate)
from Posts

/*

select count(distinct Id) as count, CreationYear, CreationMonth
from (

select Id,
substring(cast(CreationDate as nvarchar), 8, 4) as CreationYear,
substring(cast(CreationDate as nvarchar), 1, 3) as CreationMonth
from Users
where Id in(
  select OwnerUserId
  from Posts
union
  select UserId
  from Comments
)
) as alias

group by CreationYear, CreationMonth

*/

fork query

edited jun 18

created jun 18 anonymous