Can I filter by createdAt matching a Time? (ignore the date)

Prisma don't have this baked in as this is a rare use case. You can do it in your application server using some custom logic though. 🙂

Can prisma support other datetime format eg daterage/date ?

You can store them as string but we natively support ISO timestamps only