Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] drizzle studio shows wrong timestamp UTC #405

Open
christophmeise opened this issue May 13, 2024 · 0 comments
Open

[BUG] drizzle studio shows wrong timestamp UTC #405

christophmeise opened this issue May 13, 2024 · 0 comments

Comments

@christophmeise
Copy link

I have a timestamp defined in mysql with drizzle schema.

scheduledAt: timestamp("scheduledAt")

When I insert a date it is shown incorrectly in drizzle studio.

It shows in drizzle studio: 2024-05-13T13:00:00.000Z
When I go into PlanetScale I see that the actual stored value is: 2024-05-13T15:00:00.000Z

There is a two hour difference with all my dates shown only in drizzle studio which is not correct.
Both dates are in ISO 8601, so it should be the same regardless of any possible timezone issues.

The date is stored correctly in the database, so it should only be an issue with displaying the value in drizzle studio.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant