Jump to content

Retrieving Specific Data


Recommended Posts

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!

Link to comment
https://forums.phpfreaks.com/topic/270642-retrieving-specific-data/
Share on other sites

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!

The space in between the - and 24 was the problem. Solved.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.