group_by month using datefield field in SQLite

[diegocgaona]

How to group data by month using a date field?
Something like this, but by month:

     result = await model.filter(**used_filters, owner_id=user.id) \
            .annotate(value=Sum("value")).group_by("start_date").values("start_date", "value")
        return result

I'm using SQLite

[long2ice]

Try use custom function in annotate