how should I go for writing a query for findMany where I want to find rows where one DateTime property is 30 days old (or older)? not sure if I should use something like

gte

or

lte

or what I should input there

This might be helped you https://github.com/prisma/prisma/discussions/11443

the problem is that that one uses hardcoded dates, I need it to use the date from the row itself

Did you try

toDate

from date-fns to get the data?

the

createdAt

column already uses DateTime, I'm more wondering if there's a way to fetch that with a single query or can I only fetch them all at once and manually filter the array

I understand your point so could you please try

toDate

from date-fns to filter it?

sorry I don't think I quite got yours then, I looked `toDate`'s documentation but I didn't quite see what I would use of it, from what I understood it just clones the date

So I think you should try raw database access

will use raw then, thanks! prisma cool

This might also help: https://www.prisma.io/docs/guides/database/troubleshooting-orm/help-articles/comparing-columns-through-raw-queries#comparing-date-values