List:General Discussion« Previous MessageNext Message »
From:Keith Spiller Date:August 27 2008 4:26am
Subject:Time Zone Support
View as plain text  

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...


Time Zone SupportKeith Spiller27 Aug
  • RE: Time Zone SupportMartin Gainty27 Aug