android - SQLite group by/count hours, days, weeks, year - Stack Overflow
Discovered: Nov 13, 2022 10:20 android - SQLite group by/count hours, days, weeks, year - Stack Overflow <— yay for sqlite <— QUOTE SELECT strftime('%m', timestamp), count(*) FROM Data
WHERE timestamp >= strftime('%s', '2012-01-01 00:00:00')
AND timestamp < strftime('%s', '2013-01-01 00:00:00')
GROUP BY strftime('%m', timestamp); <– see also How to group by week no and get start date and end date for the week number in Sqlite?