开发者

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

开发者 https://www.devze.com 2023-02-22 04:58 出处:网络
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

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

精彩评论

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