Jump to content

SimonSaysCode

New Members
  • Posts

    3
  • Joined

  • Last visited

SimonSaysCode's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. The space in between the - and 24 was the problem. Solved.
  2. Additionally, I should mention that I am using SQLite and PHP.
  3. 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!
×
×
  • 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.