DatabaseErrorException: ERROR: column "due_date" is of type timestamp
I'm trying to use the timestamp column type and when inserting a record with a date object I get this error:
I'm creating my schema as per the developer docs but for the life of me, I cannot get the record to save because of the date.
When inserting the record I've tried { mode: "string" }, { mode: "date" } and used a
Any ideas how I can get this working?
DatabaseErrorException: ERROR: column "due_date" is of type timestamp with time zone but expression is of type text; Hint: You will need to rewrite or cast the expression.I'm creating my schema as per the developer docs but for the life of me, I cannot get the record to save because of the date.
When inserting the record I've tried { mode: "string" }, { mode: "date" } and used a
new Date()Any ideas how I can get this working?
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
