megio
megio
Explore posts from servers
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