I deal a lot with time and time zones in the software I develop, and thankfully most frameworks make it pretty easy to manage. The rule tends to be, convert and store everything in UTC, and display it in the user's time zone in the UI, and call it a day.