you'll need to set the datetime function before presenting date/time to the user
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender.
This transmission is of a confidential nature and Sender does not endorse distribution to
any party other than intended recipient. Sender does not necessarily endorse content
contained within this transmission.
> From: larentium@stripped
> To: mysql@stripped
> CC: larentium@stripped
> Subject: Time Zone Support
> Date: Tue, 26 Aug 2008 22:26:36 -0600
> 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...
Talk to your Yahoo! Friends via Windows Live Messenger. Find out how.
|• Time Zone Support||Keith Spiller||27 Aug|
| • RE: Time Zone Support||Martin Gainty||27 Aug|