i want to sum each weight by a certain date!date |weight|
-----------------------
1109746885,0 |
1110103200,11408 |
1110124465,13633 |
1110288332,0 |
-----------------------
i want to sum each date like this :
1.1.2005 08:00:00 to 2.1.2005 07:59:59
2.1.2005 08:00:00 to 3.1.2005 07:59:59
and so on....
for example
1110103200=6.3.2005 12:00
1110124465=6.3.2005 17:45:25
and both of this dates from the table i want to some as 1 date!
can i do this in 1 query ormust i run in loops over the dates?
thnaks i nadvance
peleg