tags:

views:

13

answers:

0
Q: 

How to auto select timezone in a web form & correlate it to mysql time zones

In javascript I can get the offset from UTC & whether DST is used by the users timezone.

In MySQL I have a set of timezone tables.

I'd like to auto select a timezone for the user from the MySQL tables.

The mysql tables are not easy to understand (nor can I find schema documentation). I can't figure out how to go from a UTC offset + DST flag to find the relevant time zone in the mysql.time_zone_* tables.

related questions

Displaying Time Zones in WPF/C#. Discover Daylight Savings Time Offset
Should the timezone be a constant or a variable?
TZ Multiple TimeZone under Windows
How to convert UTC time to Time in any other time zone in C#
How to store a recurring time window
UTC Offset in PHP
Determine Time Zone Offset in T-SQL
How to display DateTime with an abbreviated Time Zone?
What is the best way to detect and store the timezone the client of a web app is in?
Apache configuration help -- Why are different processes "in" different time zones?
How to retrieve time zone choices on Windows Mobile for PDA
How would you organize a timezone dropdown?
How do I use timezones with a datetime object in python?
Best way to extract a timezone from a mail Date header in Java?
Best way to extract TimeZone object from a String?
How do I convert GMT to LocalTime in Win32 C?
Resetting detection of source file changes
Web service - current time zone for a city?
How can I determine whether a given date is in Daylight Saving Time for a given timezone in .NET 2.0?
Timezone lookup from latitude longitude
Setting time zone remotely in C#
Send out email at a user's local time.
Handling timezones in storage?
Java Time Zone is messed up
How can I determine a web user's time zone?