Datetime Precision and odd Activity Column Format

(Dan Pickett) #1

We recently upgraded our discourse installation’s postgres database and in doing so, it looks like the precision was lost on all timestamps. I investigated and ensured the precision is persisting via psql and it is. It appears the JSON serialization is no longer returning the decimals for times that we’re seeing on other installations (as indicated in example:

The result (I think) is an odd display of time related information:


Can anyone point me in the right direction of what might be happening here?

(Jeff Atwood) #2

I don’t know that we ever saw this. Did you figure it out?

(Dan Pickett) #3

Hey Jeff,

Thanks for checking in! I think it was a database corruption that we resolved with a migration to a new database and a subsequent upgrade of Discourse software.

(Jeff Atwood) #4