CODEWITHSUNDEEP
mysqlsql
Mark
Mark

Reputation: 2760

Sql query to insert time zone in mysql database

Is there any query to insert country name and its time zone in GMT, for a mysql database. I want to add all the country name and its time zone difference with GMT or UTC

Upvotes: 0

Views: 1659

Answers (1)

Bhrugesh Patel
Bhrugesh Patel

Reputation: 1106

try to google the list but you may have to actually write extraction code On top of that, large countries like USA, Canada & Russia have multiple time zones Its all up to you how you want to design the database and code according to that.

This is the list Fedora is using... http://unicode.org/repos/cldr/trunk/common/supplemental/windowsZones.xml

start from here

Here is another list

http://www.timegenie.com/world.time

Upvotes: 1

Related Questions