select top 10 dateadd(hour, datediff(hour, 0, dateadd(hou...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

select top 10 dateadd(hour, datediff(hour, 0, dateadd(hour, 0, p.creationdate)), 0), u.location--, count(u.location)
from posts p
inner join users u 
on (u.id = p.owneruserid)
where p.PostTypeId = 2 -- answer
and p.creationdate >= '2013-04-04 17:00' and p.creationdate <= '2013-04-04 17:07'
--group by  dateadd(hour, datediff(hour, 0, dateadd(mi, 30, p.creationdate)), 0), location
--u.websiteurl, u.location, u.aboutme,

Enter Parameters

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