Group by hour in SQLAlchemy?

Question

How do I group query results by the hour part of a datetime column in SQLAlchemy?

Answer 1

Group by func.date_trunc(literal('hour'), date_col)

Answer 2

If I remember correctly you must first extract the hour from your timestamp and then you can group by that.

query(extract('hour', timeStamp)).group_by(hour)

Answer 3

You can also do it in Python. Assuming you have an ordered query_result :

from itertools import groupby

def grouper( item ): 
    return item.created.hour
for ( hour, items ) in groupby( query_result, grouper ):
    for item in items:
        # do stuff

This answer is adapted from an answer to a similar question here