[BUG]: TIMESTAMPS showing up incorrectly on drizzle studio. about drizzle-orm HOT 2 OPEN

I also had a similiar issue here, and I think it has to do with storing the time in UTC, and then drizzle-kit seams to assume that it is stored in your local time zone, and then converts it again to UTC, creating an offset.

I can compare these values using another database viewer like Dbeaver.

DBeaver:

DrizzleKit:

Actual Response from Drizzle ORM in Production (correct):

This means Drizzle Kit is providing a different response than Drizzle ORM.
I am using a postgres database in this case, with the date mode on.

from drizzle-orm.

Here is some more evidence to the bug. I'm using a planetscale database.

I ran this query through the drizzle studio and on the planetscale web console and got different results. The 6 hour time difference being that I'm in US Pacific time.

From drizzle studio in local dev:

From planetscale web console:

I'm not seeing this bug in drizzle ORM production code. Only on the studio side.

from drizzle-orm.