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.32k stars 1.68k forks source link

Have StarRocks store timezone data in UTC #37471

Closed alberttwong closed 3 days ago

alberttwong commented 6 months ago

As of right now 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.

Also developers need to use https://docs.starrocks.io/docs/sql-reference/sql-functions/How_to_Write_Functions_Documentation/ convert_tz to cast the time to a different timezone.

alberttwong commented 6 months ago

https://github.com/StarRocks/starrocks/issues/37090

github-actions[bot] commented 2 weeks 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!