Database design

Pop your questions regarding Home automation software here.....
User avatar
nico_gh2
Member
Member
Posts: 133
Joined: Wed Apr 06, 2011 12:24 pm
Location: Betuwe, Netherlands
Contact:

Re: Database design

Post by nico_gh2 »

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,...
Romac
Starting Member
Starting Member
Posts: 47
Joined: Tue May 11, 2010 9:45 pm
Location: Utrecht, Netherlands

Database design

Post by Romac »

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
HS3, Z-Wave Network, CommandFusion GUI
Post Reply

Return to “Questions & Discussions Forum”