© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago•
8 replies
ptrxyz

TIMESTAMPTZ is returned as string instead of Date object

It seems that drizzle upon initialization (re-)sets
pg-types
pg-types
handling of dates. Usually
pg-types
pg-types
and thus
node-postgres
node-postgres
converts
TIMESTAMP
TIMESTAMP
,
TIMESTAMPTZ
TIMESTAMPTZ
and other related data base types automatically to a JS date object.

I tried Drizzle with the node-postgres driver and it didn't seem to work, dates were simply strings. I figured that Drizzle resets the default type convertes upon initialization (see picture).

I was wondering why that is. And is that simply a me problem or did anyone also find
TIMESTAMP
TIMESTAMP
being returned as
string
string
when using
node-postgres
node-postgres
?
image.png
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

date column not being returned as string by drizzle
Drizzle TeamDTDrizzle Team / help
3y ago
numeric as number instead of a string
Drizzle TeamDTDrizzle Team / help
13mo ago
Why is 1 and 0 are returned as string?
Drizzle TeamDTDrizzle Team / help
3y ago