SimonSaysCode
-
Posts
3 -
Joined
-
Last visited
Posts posted by SimonSaysCode
-
-
Additionally, I should mention that I am using SQLite and PHP.
-
Hello All,
So I am attempting to get the previous day's data from my table, but I want it to be averaged by hour (I have an entry for every 5 minute interval).
So I assumed it would look something like this:
$sth = $db->prepare("SELECT AVG(Power) AS AvgPower, strftime('%H', Timestamp, 'unixepoch', 'localtime') AS TheDate FROM TestTable WHERE datetime(Timestamp, 'unixepoch') >= datetime('now', '- 24 hours') GROUP BY TheDate");
This isn't working however, so I was hoping someone could tell me where I am going wrong.
Thanks!
Retrieving Specific Data
in Other RDBMS and SQL dialects
Posted
The space in between the - and 24 was the problem. Solved.