> -----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 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 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 produces the following table: > > > > You don't tell us what this "certain period" is, in general you use date > > & time functions to manipulate time. If your period was one hour, you > > could use something like this: > > Apologies, I was hoping that the time period would be "dynamic", as it's > being called from a php script, which might choose an overall period of 7 > days, split into 3 hour periods, or 24 hours, split into half hour > periods. > > > > > 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?
Also I've spotted another problem, in the fact that I only have the date/time as a unixtime stamp! Is there a way within the MySQL query of changing a unixtime stamp to something meaningful? > > Thanks > James > > > > > <URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html > > > > > -- > > Roger > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
