hopesix
Explore posts from serversDTDrizzle Team
•Created by hopesix on 2/7/2024 in #help
Can't edit datetime column in drizzle studio "Error: value.toISOString is not a function"
It's specifically an issue with how Drizzle Studio is displaying the Date column, it's altering it via JS
6 replies
DTDrizzle Team
•Created by hopesix on 2/7/2024 in #help
Can't edit datetime column in drizzle studio "Error: value.toISOString is not a function"
So I managed to edit the datetime inside of sequel ace connecting it to the db
6 replies
DTDrizzle Team
•Created by hopesix on 2/7/2024 in #help
Can't edit datetime column in drizzle studio "Error: value.toISOString is not a function"
6 replies
DTDrizzle Team
•Created by hopesix on 2/7/2024 in #help
Can't edit datetime column in drizzle studio "Error: value.toISOString is not a function"
I realized that I never specified
mode on the datetime columns, but they should have defaulted to 'string' anyways.
I also connected via Sequel Ace and was able to edit and save a change in start_time, the display of the columns is quite different in Sequel Ace (see my next post in this thread for screenshots)
However, if I have mode: "string" set for
startTime: datetime("start_time", { mode: "string" }).notNull()
Then I can't seem to insert into my db as a new Date(), Luxon's toJSDate() or as an toISO() or even just a string like temp.
As soon as I specified mode: string I seem to have lost the ability to insert bookings at all with Drizzle.6 replies