Prisma Date Day Off

Hello,

I currently have the following:

model SomeModel {
  date    DateTime  @db.Date()
}

model SomeModel {
  date    DateTime  @db.Date()
}

model SomeModel {
  date    DateTime  @db.Date()
}

model SomeModel {
  date    DateTime  @db.Date()
}

prisma.somemodel.insert({
  data: {
    date: new Date("2023-06-10")
  }
});

prisma.somemodel.insert({
  data: {
    date: new Date("2023-06-10")
  }
});

prisma.somemodel.insert({
  data: {
    date: new Date("2023-06-10")
  }
});

prisma.somemodel.insert({
  data: {
    date: new Date("2023-06-10")
  }
});

but the problem is that it saves the date as 2023-06-09 in the PostgreSQL database. Idk how to fix this

Solution

I just added

UTC

UTC

UTC

UTC after the day, got fixed, thanks

Jump to solution

EEQ Hello, I currently have the following: ```prisma model SomeModel { date Da...

Sunless•6/10/23, 8:00 PM

postgres saves time in the UTC +0 Timestamp

Sunless•6/10/23, 8:00 PM

in your case the

new Date()

new Date()

is auto timestamped to your local time, and when passing to postgres, it is converted from your local time to

UTC

UTC

in which case it has a chance to go to the previous day

Sunless•6/10/23, 8:02 PM

example if you life in UTC+2 and run the insert statement at 10 June 2023, 01:00 AM10 June 2023, 01:00 AM, when passing to postgres it is converted to 09 June 2023, 11:00 PM09 June 2023, 11:00 PM as

UTC

UTC

is behind by 2 hours

Sunless•6/10/23, 8:02 PM

so to fix it just timestamp your date

EQOP•6/10/23, 8:02 PM

Ah okay, thanks

Solution

EQ•6/10/23, 8:05 PM

I just added

UTC

UTC

after the day, got fixed, thanks

Prisma Date Day Off

Similar Threads

Similar Threads

Similar Threads