created, updated and submitted_date in DB are wrong
I updated a manuscript at almost exactly 4:29pm NZ time. NZ time is 12 hours ahead of UTC. I expected the updated
field in the DB to have a value near
2021-06-24 04:29:00.000+00
but instead, the database contains:
2021-06-22 10:59:36.747+00
which is 1 day, 17 hours, 29 minutes and 23 seconds earlier than expected.
The created
and submitted_date
fields are similarly affected, and repeated testing shows the offset remains consistent in all cases: 1 day, 17 hours, 29 minutes and about 23 seconds early.
This is a problem for reporting: when I query for manuscripts within a certain date range I am not getting the manuscripts I expect.