I spend a surprisingly large amount of time debugging datetime issues between our legacy codebase and new data and applications. One piece of advice to anyone starting a greenfield project is to keep all datetimes as unix second timestamps around any storage or api calls.