I'm not sure if this syntax is exactly right, but would something like this work?
SELECT HOUR(datetime) AS myHour, FLOOR(MINUTE(datetime) / 5) * 5 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 -- 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 !!
