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

Attribute Ui: True support for "local" date/time #370

Open
rpbouman opened this issue Jan 8, 2025 · 0 comments
Open

Attribute Ui: True support for "local" date/time #370

rpbouman opened this issue Jan 8, 2025 · 0 comments
Labels
enhancement New feature or request

Comments

@rpbouman
Copy link
Owner

rpbouman commented Jan 8, 2025

We currently have "iso" and "local" derivations for temporal types, but these are probably not doing exactly what they should do.

  • For DuckDB temporal types that do not support a time zone, one can debate what the correct interpretation should be:

    • Should they be interpreted as absolute (UTC)?
    • Should they be interpreted as being in some timezone chosen by the user?
    • Maybe some other item in the dataset suggests what the timezone should be? It could be that the timezone is in a separate column, or it could be that there is country/region information that should be used as the locality, determining the tz.
  • For the ones that have an explicit timezone, it is at least absolutely clear what the time is.
    In these cases, one could desire to see the value in the user's local time

@rpbouman rpbouman added the enhancement New feature or request label Jan 8, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant