Home Automation Domotica Forum Europe, Bwired Forum

At the moment all my data is in SQL Server and would like to stay with this solution. Just looking for a SQL query to group the data by day/week/month/year...

guess BETWEEN and DATEADD might help; BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL -7 DAY)
google is your friend for further solutions like; last week, last month, this month etc,...

Thanks for your reply. I managed to get some graphs generated where I display daily use. Now working on getting the hourly use visible.


Sent from my iPhone using Tapatalk