© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•16mo ago•
5 replies
adrtivv

column is of type date but expression is of type text

So, I was trying this and it resulted in an error:
column \"date_of_birth\" is of type date but expression is of type text
column \"date_of_birth\" is of type date but expression is of type text

It happened when I tried updating multiple columns of multiple rows of a table. It doesn't happen when multiple columns of a single row are being updated. What causes this? I asked another person and they said that it's not necessarily a postgres issue and probably has somethi to do with drizzle orm.
Drizzle ORM - Update many with different values for each row
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

column "roles" is of type integer[] but default expression is of type integer
Drizzle TeamDTDrizzle Team / help
2y ago
DatabaseErrorException: ERROR: column "due_date" is of type timestamp
Drizzle TeamDTDrizzle Team / help
2y ago
Custom column type
Drizzle TeamDTDrizzle Team / help
16mo ago
recommendation on changing data type of column?
Drizzle TeamDTDrizzle Team / help
13mo ago