search

StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.27k stars 1.67k forks source link

Store timezone tz info as part of timestamps #37090

Open alberttwong opened 6 months ago

alberttwong commented 6 months ago

StarRocks: We don't store tz info in timestamp. So they will have to handle tz at the application layer. ie. always store timezone in UTC in the db, and convert to user's local tz at retrieval time.

alberttwong commented 6 months ago

https://www.reddit.com/r/dataengineering/comments/18fxgna/current_data_setup_cannot_handle_userfacing/

alberttwong commented 6 months ago

https://docs.starrocks.io/docs/administration/timezone/

github-actions[bot] commented 1 week ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!