We need to add support for time zone to our existing PHP "Board Member" Extranet
applications. Could those of you with experience supporting a time zone field in your
MySQL data tables offer some advice? Would you use a single field? Would you use just an
offset value? How would you represent the information on presentation data? How would
you list the time zone options in your form dropdowns? Would you use a separate time zone
table to support the offset values, an abbreviated time zone, a full time zone name and a
daylight savings time value?
We greatly appreciate any advice you can offer.
Thank you for taking the time to share your knowledge...