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


Reply via email to