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

Date display issue with multiple timezones #4442

Open
Lelenaic opened this issue May 21, 2024 · 3 comments
Open

Date display issue with multiple timezones #4442

Lelenaic opened this issue May 21, 2024 · 3 comments

Comments

@Lelenaic
Copy link

Lelenaic commented May 21, 2024

* Describe the bug

When creating a date (without time) field in a general collection, the date is stored with a datetime with timezone format in PostgreSQL.
When someone in GMT+3 creates a record with a date 2024-05-21, PG stores "2024-05-20 21:00:00+00".
But when I display the date in GMT+2 in nocobase, I see 2024-05-20 (because the datetime is 2024-05-20 23:00:00 in GMT+2), but, it should still display 2024-05-21.

* Environment

  • NocoBase version: v1.0.0-alpha.15
  • PostgreSQL 16
  • Deployment Methods: Docker
  • Docker image version: latest

* How To Reproduce

  1. Use postgresql
  2. Create a general collection with a date field (without the time)
  3. With a computer in a timezone, creates a record with a date.
  4. See the record on a computer with a different timezone (smaller than the previous one, if created in GMT+3, see in +2).

Expected behavior

When the time is not displayed, the date should ignore the browser timezone to display the original date whatever the current user timezone is.
I've seen the PR #4366 talking about this issue but with an example about charts, but it should work like this everywhere.

@hongboji
Copy link
Contributor

Sorry for not replying in time, we have discussed this issue and followed up with planning to resolve it

@MarekVigas
Copy link

Is there any update on this ? I have the same problem.

@zhouyanliang
Copy link
Contributor

Is there any update on this ? I have the same problem.

Sitll in progress

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

4 participants