MS sql I will post the code I use tomorrow
Sent from Gmail for mobile On 2/12/10, adam <[email protected]> wrote: > 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 !! -- Sent from Gmail for mobile | mobile.google.com -- 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 !!
