开发者

Allow users to select a time zone and use it during MySQL SET time_zone

I am trying to implement a time zone option on a web application. I want to use SET time_zone and it w开发者_C百科orks fine. Where can I find a complete <select> list that has all the time_zone options available for the user to select from. Thanks

EDIT: I would like to use the 'US/Central' format and not '+10:00'


You can find that list at http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html where it's explained how time zone settings are dependent on what your OS is supporting.


Well, this is not a proper answer to your question but you can give it a try. Visit this link. It's my demo when I was trying to get timezones by country. Maybe, you can adapt that code to your needs.

Allow users to select a time zone and use it during MySQL SET time_zone

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜