Prisma•11mo ago

Get the next date with prisma

  const course = await db.course.findFirst({
    where: {
      slug: params.slug,
    },
    include: {
      courseDate: { // i want the next one from NOW
        orderBy: {
          from: 'asc',
        }
      },
    },
  });

  const course = await db.course.findFirst({
    where: {
      slug: params.slug,
    },
    include: {
      courseDate: { // i want the next one from NOW
        orderBy: {
          from: 'asc',
        }
      },
    },
  });

guys i want to get next courseDate from today and only that one. how can i do that using this query? 🙂

6 Replies

tyler4949•11mo ago

Probably makes sense to add that to your query, right? Something like this:

where: {
  slug: params.slug,
  courseDate: {
    gt: new Date().toUTCString()
  }
},

where: {
  slug: params.slug,
  courseDate: {
    gt: new Date().toUTCString()
  }
},

sommeeeROP•11mo ago

ok. any particular reason to use .toUTCString()?

tyler4949•11mo ago

That was just assuming you stored your dates in UTC in the db

sommeeeROP•11mo ago

i do, but isnt new Date() enough? under the hood its just a timestamp since epoch

tyler4949•11mo ago

Then you’re probably good. I was just trying to convey it should be UTC time (or the same timezone as your db) My suggestion was high level, not exact code for your solution

sommeeeROP•11mo ago

alright:) thanks!

Gaming

Programming

Get the next date with prisma

Did you find this page helpful?