aerie icon indicating copy to clipboard operation
aerie copied to clipboard

Resolve inconsistencies when setting Postgres intervals in DB

Open camargo opened this issue 2 years ago • 1 comments

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:

  1. Update spans action so we just set the interval (no math because the DB gives inconsistent behavior) (easier)
  2. 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

camargo avatar Jul 27 '23 21:07 camargo

The addExternalProfile action inserts the offset_from_plan_start column using the days HH:MM:SS format

Mythicaeda avatar Sep 27 '23 19:09 Mythicaeda