NASA-AMMOS / NASA-AMMOS/plandev
Resolve inconsistencies when setting Postgres intervals in DB
Open
@mattdailis is already working on this.
Since Jul 31, 2023.
database
investigate
refactor
- Dominant language
- Java
- Stars
- 128
- Forks
- 33
- Avg merge
- 1d 17h
- Merged PRs (30d)
- 12
Description
We have some inconsistencies in how Postgres interval strings are stored in the database.
For example 1 day vs 24:00:00. How can we configure the DB to store a single format (i.e. hh:mm:ss.mmm)?
There are a couple tasks associated with this ticket:
- Update spans action so we just set the interval (no math because the DB gives inconsistent behavior) (easier)
- How do we enforce a consistent interval format across the DB (harder)
- Break this out into another ticket if needed
See: https://jpl.slack.com/archives/CJ07FGRPH/p1690482612292829
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.