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
We have some inconsistencies in how Postgres interval strings are stored in the database.
For example
1 dayvs24: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:
See: https://jpl.slack.com/archives/CJ07FGRPH/p1690482612292829