Hi,
I hope that someone can help me with a SQL statement.
I dont know if this is the right place to ask the question, if not please redirect me.
I have a table in my MySQL database named "data" with the following fields
date : UNIX Timestamp
Datasize : Int
now i would like to do something like this
select sum(datasize) from data
group by ( this is the problem. I would like to be able to group on hours, 10 min, 30
min and so on, one at a time)
Can someone help me completing the statement ?
Yours
Erik Aaskoven