Hello, I have a SQL query example, I need to perform in Prisma Example:

SELECT * FROM table1 
WHERE '2011-01-01' BETWEEN table1.startdate AND table1.enddate

How I can perform this operation in Prisma ?

I think you’re trying to do this…. docs here would look something like

const result = await prisma.post.findMany({
  where: {
    AND: [
       date_created: {
         gte: new Date(startdate)
       },
       date_created: {
         lte: new Date(enddate)
       },
    ]
  },
})

fyi, I don’t work for Prisma so might not be the best answer.

Thank you @Tyler Bell 🙂