mysql - How does one deal with multiple TimeZones in applications that store dates and times?

Question

I realize this is a bit subjective, but I'm hoping to pick everyones brain here on how they deal with multiple timezones? There are a variety of similar questions here and an equally wide variety of accepted answers.

How have you delt with this in apps you've built, and what issues did you have to overcome?

Answer 1

You always store date/time in one time zone(9 out of 10 it is London time) and convert it on display to the timezone of your user. This is strictly application level issue not the db.