Skip to content

Move our DateTime columns over to being explicitly UTC

David Kettler requested to merge member-portal-204-timezone-aware-db-columns into dev

@DSASanFrancisco/portal-members

SUMMARY

Write-up in ticket: https://trello.com/c/jGi7pwM2/204-make-all-datetimes-in-the-api-explicitly-utc

This PR follows the first outlined approach, where we load all datetimes from the DB as timezone-aware UTC datetimes. Before merging, we may want to consider whether or not we believe any dates in the DB were not meant to be UTC, and write and run a migration moving them to UTC. As I don't have much historical context, I didn't feel qualified to make that assessment, but would be happy to help write & run that migration if we think it's needed.

Merge request reports