One minute increments is a little easier
SELECT HOUR(datetime) AS myHour,
MINUTE(datetime) AS myMinute,
count(hit_id) AS myHits
from tbl_dns_hits
where WHERE (dns_id = '#dns_lookup.dns_id#') and (dns_hit_datetime
between #sixty_previous# and #now()#)
group by myHour, myMinute
Does the query work? Are you using MySQL?
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en
!! save a network - please trim replies before posting !!
