drizzle-team / drizzle-team/drizzle-orm

[BUG]:Drizzle Studio shows converted UTC time for timestamp array columns

Open
#4,041 0 comments 0 reactions 0 assignees View on GitHub
drizzle/studio improvement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

^0.36.0

### What version of `drizzle-kit` are you using?

^0.27.1

### Other packages

_No response_

### Describe the Bug

I have these three columns
javascript
```
availableFrom: timestamp("available_from").notNull(),
availableTill: timestamp("available_to").notNull(),
unavailableDates: timestamp("unavailable_dates")
.array()
.default([])
.notNull(),
```

When I enter the same date "2025-01-29T18:30:00.000Z", the studio shows "2025-01-29T18:30:00.000Z" in the case of first two columns but for the array one it shows "2025-01-29T13:00:00.000Z" which is the UTC version of original date + my timezone (given you ignore the Z)

my column is not supposed to store timezones which is correct as I've verified with other clients and cli, Only the drizzle studio is showing the incorrect dates

![Image](https://github.com/user-attachments/assets/28e51711-05db-49c5-afba-c15d9f3d367f)

Even though nothing is breaking it's still a bit confusing and would be better if it showed the date as it was stored.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.