megio
megio
Explore posts from servers
SSolidJSDTDrizzle Team
PostsComments
DTDrizzle Team
Created by megio on 3/18/2024 in #help
Error due to Date when I try to update a DB record
Hello everybody! I have a really weird issue and I don't understand: I have created a Postgres DB record with this code: 
...code before...
await.db
.insert(MyTable)
    .values({
      ...data,
      createdAt: new Date(),
      updatedAt: new Date(),
    })
...code after...
...code before...
await.db
.insert(MyTable)
    .values({
      ...data,
      createdAt: new Date(),
      updatedAt: new Date(),
    })
...code after...
And since here everything is fine. When I am going to update my record, I would like to do something like: 
...code before...
await db
    .update(MyTable)
    .set({
      ...data,
      updatedAt: new Date(),
    })
...code after...
...code before...
await db
    .update(MyTable)
    .set({
      ...data,
      updatedAt: new Date(),
    })
...code after...
But I am receiving this error TypeError: value.toISOString is not a function. I think I know what is the problem cause I have encountered it before, when I tried to save the createdAt an updatedAt from the request body from the front end, passing them new Date() as values. I think that now, when I am spreading my ...data I have a createdAt field inside of it that causes me that error, but it has no sense! My DB schema for those two Dates is: 
createdAt: timestamp("createdAt").defaultNow().notNull(),
updatedAt: timestamp("updatedAt").defaultNow().notNull(),
createdAt: timestamp("createdAt").defaultNow().notNull(),
updatedAt: timestamp("updatedAt").defaultNow().notNull(),
Why I am receiving that error? It seems like something broken is happening behind the scenes. Thanks for the help!
2 replies