Managing DateTime Fields

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

const start = new Date("2026-01-01");
const end   = new Date("2026-12-31T23:59:59.999Z");
await prisma.order.findMany({
  where: { createdAt: { gte: start, lte: end } }
});

const rows = await prisma.$queryRaw`
  SELECT DATE_TRUNC('month', "createdAt") AS month, COUNT(*) AS cnt
  FROM "Order" GROUP BY 1 ORDER BY 1`;

await prisma.task.findMany({
  where: { dueDate: { lt: new Date() } }  // overdue
});

const days = 7;
const since = new Date(Date.now() - days * 86400_000);
await prisma.activity.findMany({ where: { createdAt: { gte: since } } });