r5 icon indicating copy to clipboard operation
r5 copied to clipboard

Normalize createdAt/updatedAt timestamps

Open ansoncfit opened this issue 6 years ago • 3 comments

At least in the modifications collection, some timestamps appear to be saved as NumberLong and others as ISODate

ansoncfit avatar Nov 22 '18 10:11 ansoncfit

Can these be normalized with a single update query? I'm guessing it hasn't been done yet just out of caution about blanket-updating a production database.

abyrd avatar Apr 11 '19 03:04 abyrd

See https://github.com/conveyal/analysis-ui/pull/878

ansoncfit avatar Sep 12 '19 15:09 ansoncfit

Upon initial creation, objects have proper Dates. But upon first inspection from the UI they have been translated to integer timestamps. This means that upon save/update, those timestamps will be stored as longs instead of as a Date.

At some point conversion is happening on the way to the UI.

trevorgerhardt avatar Oct 13 '20 15:10 trevorgerhardt