Hi, 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... Keith