I have a database where a new entry gets added every minute.
I want to make a query where the result is in an intervall of 1 hour (e.g. 2016-06-19 20:01, 2016-06-19 21:01, ...).
This is my current approach (I used minute 42 of every hour, because that might only occur in the minutes part of the date):
SELECT * FROM 'raw_data' WHERE CONTAINS ('date', "42")>0