aerie
aerie copied to clipboard
Resolve inconsistencies when setting Postgres intervals in DB
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
The addExternalProfile action inserts the offset_from_plan_start column using the days HH:MM:SS format