What is the recommended way to query a dateTime field when you want posts created/edited on a particular date?

Hey 👋🏾 One suggestion would be using the

gte

and

lte

filters to query

DateTime

values. Assuming you have the following schema:

model Post {
  id        String   @id @default(cuid())
  title     String
  createdAt DateTime @default(now())
}

You could filter the post’s

createdAt

field as follows:

await prisma.post.findMany({
  where: {
    createdAt: {
      gte: new Date(/** range start */).toISOString(),
      lte: new Date(/** range end */).toISOString(),
    }
  }
})

I guess if I have a date like June 14, I will need to create a June 13 and a Jun 15 to make the filtering work.

Yes. I would recommend specifying the year as well to narrow down your search, for example:

new Date('2020 June 14').toISOString()

is:

'2020-06-13T21:00:00.000Z'

Thanks Alex. Love Prisma, but hoping there's more in-depth date filtering methods in the future like the other ORMs.

Are there any specific date filtering methods you think might be lacking in Prisma? Happy to hear your thoughts and help us improve the existing DX 🙂

Coming from Django, there are more robust methods like these that offer more control and are less code. https://docs.djangoproject.com/en/4.0/ref/models/querysets/#date

If you don’t mind, could you create a feature request – stating the example filters we could provide when working with DateTime values? 🙂

I think I already have, let me check. If I haven't I will now. Thanks for all the help. Appreciate it. 🙂