我试着分割一个小时的数据,六个小时的数据,六个月的数据,我已经看过MySQL的大部分答案,如何在sqlite中实现?我尝试过使用sqlite查询:
SELECT timestamp,usage FROM network_band WHERE timestamp <= '2017-08-17 10:57:26' and timestamp >= '2017-08-17 09:57:26' and mac='68:c4:4d:8b:65:dd' GROUP BY strftime('%H:%M:%S 00:00:00',