Weird bug in dates

Hello guys im facing a weird bug im using MySQL,
the date stored in the db is : 2023-11-08 04:37:53.231 -> readable ( 2023-11-08 04:37:53 )
and if i use prisma to retrive it i get: 2023-11-08T04:37:53.231Z -> readable ( 2023-11-08 06:37:53 )
any idea on why this is happening and what might the problem be and how to fix it?

const lesson = await prisma.lesson.findUnique({
    where: { id: +id }
})

{
  id: 3,
  link: 'video.mp4',
  title: 'some title',
  description: 'some desc',
  courseId: 1,
  rating: 4,
  views: 454,
  createdAt: 2023-11-08T04:37:53.231Z,
  updatedAt: 2023-11-08T04:37:53.231Z
}

const lesson = await prisma.lesson.findUnique({
    where: { id: +id }
})

{
  id: 3,
  link: 'video.mp4',
  title: 'some title',
  description: 'some desc',
  courseId: 1,
  rating: 4,
  views: 454,
  createdAt: 2023-11-08T04:37:53.231Z,
  updatedAt: 2023-11-08T04:37:53.231Z
}

Prisma•3y ago•

33 replies

DaYroXy

Weird bug in dates

const lesson = await prisma.lesson.findUnique({
    where: { id: +id }
})

{
  id: 3,
  link: 'video.mp4',
  title: 'some title',
  description: 'some desc',
  courseId: 1,
  rating: 4,
  views: 454,
  createdAt: 2023-11-08T04:37:53.231Z,
  updatedAt: 2023-11-08T04:37:53.231Z
}

const lesson = await prisma.lesson.findUnique({
    where: { id: +id }
})

{
  id: 3,
  link: 'video.mp4',
  title: 'some title',
  description: 'some desc',
  courseId: 1,
  rating: 4,
  views: 454,
  createdAt: 2023-11-08T04:37:53.231Z,
  updatedAt: 2023-11-08T04:37:53.231Z
}

Weird bug in dates

Similar Threads

Weird bug in dates

Similar Threads

Similar Threads

Similar Threads