We should use Timestamp With Time Zone
Open
database
devops
server
tech debt
workers
- Dominant language
- Python
- Stars
- 13
- Forks
- 17
- Avg merge
- 6h 59m
- Merged PRs (30d)
- 1
Description
> [!NOTE]
> Migrated from [augurlabs/augur#1370](https://github.com/augurlabs/augur/issues/1370)
> Originally opened by `@jberkus` on 2021-07-22
---
Currently all timestamps in the database are TIMESTAMP WITHOUT TIME ZONE. This prevents the user from easily querying the database in their own local time zone, which leads to confusion when the user compares the timestamp they see in the Github/lab UI with the timestamp they see in the database. Further, it may be causing data issues if the GH API and the GL API are not using the same timezone (are they?).
We should figure out what time zone each of github and gitlab are using, and store them as TIMESTAMPTZ.
Contributor guide
Assessment
This issue has not been assessed yet.