Get posts posted during a specific time

1

Please login or register to vote for this query.

(click on this box to dismiss)

Blender Meta

Q&A about the site for people who use Blender to create 3D graphics, animations, or games

select p.Id, p.OwnerUserId, p.PostTypeId, p.CreationDate, p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount, p.closedDate, PostTags.TagId, Tags.TagName
from Posts as p
  inner join PostTags on p.Id = PostTags.PostId
  inner join Tags on PostTags.TagId = Tags.Id
where convert(date, CreationDate) >= convert(date, '20180815')
      AND convert(date, CreationDate) <= convert(date, '20180815')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results