Answers posted by users within specific creation date

1

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT *
FROM Posts p
INNER JOIN Users u ON u.Id = p.OwnerUserId
WHERE convert(date, u.CreationDate) = convert(date, ##regDate:string##) 
AND convert(date, p.CreationDate) >= convert(date, ##Start:string##)
AND convert(date, p.CreationDate) <= convert(date, ##End:string##)
AND p.PostTypeId = 2
ORDER BY u.Id, convert(date, p.CreationDate)

Enter Parameters

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