Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Teamβ€’13mo agoβ€’
3 replies
nu

Changing postgres timestamp mode (string -> date) isn't reflected in migrations

Hi.
I have my migrations generated and applied from my initial schema.
Now in the schema I changed to
mode: 'date'
mode: 'date'
in multiple timestamp columns (ex:
time: timestamp({ withTimezone: true, mode: 'date' }).notNull(),
time: timestamp({ withTimezone: true, mode: 'date' }).notNull(),
). This was
mode: 'string'
mode: 'string'
by default previously.

Now when I run the
drizzle-kit generate
drizzle-kit generate
command, no migrations are generated. I made this change to multiple columns.
Is this a bug or is it expected behaviour?
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

Timestamp from Postgres returns date object despite schema using string mode?
Drizzle TeamDTDrizzle Team / help
3y ago
When using Postgres and timestamp, what does the mode string or date actually do?
Drizzle TeamDTDrizzle Team / help
3y ago
Postgres.js type error string/date
Drizzle TeamDTDrizzle Team / help
2y ago
Greater than comparisons with timestamp mode string
Drizzle TeamDTDrizzle Team / help
15mo ago