Skip to content

Resolve inconsistencies when setting Postgres intervals in DB #1045

@camargo

Description

@camargo

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

Metadata

Metadata

Assignees

Labels

databaseAnything related to the databaseinvestigateIssue needs further investigationrefactorA code change that neither fixes a bug nor adds a feature

Type

No type

Projects

Status

In Review

Relationships

None yet

Development

No branches or pull requests

Issue actions