Hello,
I have a mysql database called sensor_data. Every 30 minutes a script inserts the power usage to this database and also the cost depending on the day/night tariff
Rec Date Time Reading Usage Cost Tar
2771 2010-12-20 16:00:00 RFXPower 67044.6 0.5 0.09 0.18
What I am looking for is a mysql query that will return the last hour hour power usage and cost. Another query...