Topics

Theo's Typesafe Cult•12mo ago

Prisma Date Day Off

Hello, I currently have the following:

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")
  }
});

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 after the day, got fixed, thanks 🙂

Jump to solution

3 Replies

Grey•12mo ago

postgres saves time in the UTC +0 Timestamp in your case the new Date() is auto timestamped to your local time, and when passing to postgres, it is converted from your local time to UTC in which case it has a chance to go to the previous day example if you life in UTC+2 and run the insert statement at 10 June 2023, 01:00 AM, when passing to postgres it is converted to 09 June 2023, 11:00 PM as UTC is behind by 2 hours so to fix it just timestamp your date

EQ•12mo ago

Ah okay, thanks

Solution

EQ•12mo ago

I just added UTC after the day, got fixed, thanks 🙂

Theo's Typesafe Cult Join

21KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Prisma type issueI'm having a difficult time figuring out why this error is occurring (pictured). I created a model Portfolio websiteHey I am new to corporate world. Currently working as full stack developer and have 11 months of exp Using JSZip with Zod and tRPCI am making a uploadRouter for my website where a user can upload 5-10 images. I want to be able to NextJS Website BugHi so I coded up a simple website using Nextjs and TailwindCSS and it looks fine on localhost but on DrizzleORM drops tables already in database when trying to add new tables?Im trying to add some new tables to the DB with drizzle, but the db already had data in it through p What is the point of learning Node.js?I can build API just with t3 app, so why would I bother learning node?ESLint changes don't show when running turbo buildHi, in my .eslintrc.cjs file I've made some changes which include warning instead of throwing errors tRPC / React query noobish questionHi, I have this Query: const { data: cardSetQuery, refetch: cardSetQueryRefetch } = api.exampl Uploadthing + NextJS (App Dir) API Loop BugAs shown in the video, i dont think there much else to say...Default Discord AuthThis my first time using T3 Stack and i am facing this issue any help