Page 3 of 3

Re: Database design

PostPosted: Wed Feb 24, 2016 5:29 pm
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,...

Database design

PostPosted: Thu Feb 25, 2016 6:41 am
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