How to extract data from the table and average at time intervals

A

Anonymous

Guest
Hello to all.
From a mysql table I would like to extract all the data of a column and average the values of every 30 minutes (for example the average of all the values between 00:00 and 00:29, then the average of the values between 00:30 and 00:59 and so for the rest of all values).
How could I do?
Thanks a lot, bye.
 
Back
Top