Prisma

What's the best approach to get an object/s by the month they were created. Like get all the object for the month of may and year 2022.

Do you mean that you are storing full dates and want to filter on the month/year of the date?

Yes, I am using this.

```  createdAt      DateTime   @default(now())
  updatedAt      DateTime   @updatedAt```

```  const events = await prisma.posts.findMany({
    where: {
      userId : 1,
      createdAt: {
        gte: new Date("May 2022"),
        lt:  new Date("June 2022")
      }
    },
    skip: 0,
    take: 50
  });```
Right now I have tried this. Works, but was wondering if there are better solutions.

Yes, I am using Postgres.

The problem with above is I will have to know what the next month is and in cases like December will also need to specify which year it is.

For filtering gte and lt operators are the preferred way without using raw queries

Maybe Prisma could add features like this from Django?

<https://docs.djangoproject.com/en/dev/ref/models/querysets/#year>

```Entry.objects.filter(pub_date__month=12)
Entry.objects.filter(pub_date__month__gte=6)```

Could you create a feature request for this <https://github.com/prisma/prisma/issues/new?assignees=&amp;labels=&amp;template=feature_request.md&amp;title=|here>?