Grouping by year, month, day

[madvas]

I'm not sure if it's currently possible, but I didn't find anything related to that.

I mean, to be able to use group_by in json query for some Date, DateTime column, but to group by only by year or month or day, etc.

In sqlalchemy it's done somehow like this

import sqlalchemy as sa
DBSession.query(Article).group_by( sa.func.year(Article.created), sa.func.month(Article.created)).all()

[jfinkels]

Seems like a valid feature...