how do you deal with timezone issues?
mysql, php, postgresql, sqlite, timezone
Solution
These are the key points to the strategy I tend to use.
- Every date is UTC internally to the system.
- Users are shown dates in the their local timezone.
- We allow users to override the timezone they are using in case they travel and they want to keep the timezone consistent.
- Make the timezone easily visible. Either display it with the time or as part of the column header.
Problem
For a scheduling system, what's the best way to save the timezone of client/event in a central server database coming from multiple sources mobile,web,client app. - How do you store the dates? Alarms, reminders etc... - How do you handle the DST setting? - How do you handle the events if client has traveled to a different location? I need the solution to work with all databases in tags.