James Nunnerley wrote:
I'm trying to create a table, and ultimately a graph, out of some syslog
data.
I have a table with the following info in it:
Time (unixtime stamp), bytes rcvd and bytes sent
I want to create a sql statement that group the data over a certain period
of time, and
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 16:03
To: [EMAIL PROTECTED]
Cc: James Nunnerley
Subject: Re: sum queries
James Nunnerley wrote:
I'm trying to create a table, and ultimately a graph, out of some syslog
data.
I have
-Original Message-
From: James Nunnerley [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 16:13
To: 'Roger Baklund'; '[EMAIL PROTECTED]'
Subject: RE: sum queries
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 16:03
To: [EMAIL
James Nunnerley wrote:
* Roger Baklund:
select date_format(ts,%Y-%m-%d %H) period,sum(rcvd),sum(sent)
from mytable
group by period;
So the below query above will allow me to group by hour - which is quite
useful - is there anyway of grouping by say 3 hour periods?
Not using the date_format()