search

Signal-Cartel / EveScoutRescue

Web site and data tools for evescoutrescue.com, maintainer ThriceHappy.
https://evescoutrescue.com/home/
13 stars 10 forks source link

Store all dates in db as UTC #197

Closed Thricehappy closed 4 years ago

Thricehappy commented 6 years ago

Right now, we convert some dates to UTC before inserting, and we convert some dates to UTS when displaying. This is inconsistent and confusing.

Instead, store all dates in db in UTC and then there is no need to convert ion display.

Thricehappy commented 6 years ago

ESRC data seems to be good now. All dates are being inserted as UTC. SAR is structured differently, but also datetime is less critical for those records.

Will keep an eye on it for now and continue to tackle as needed. But this is mostly good for now. Setting to Low Prio.

adeadparrot commented 4 years ago

PR#299 should have covered this