search

dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
7.3k stars 2.54k forks source link

In This How We Know TimeZone #617

Open urmishsolanki2225 opened 1 year ago

urmishsolanki2225 commented 1 year ago

Hear Canada 6 Time Zone , How We know Specific Time Zone For Specific City

mpathy commented 1 year ago

Use a TimeZone API against it, there are so many sources..

If you want to store it, you could go trough the whole SQL table via coordiantes: https://timeapi.io/api/Time/current/coordinate?latitude=38.9&longitude=-77.03

Then save the result in a new column

Of course would be nice if already integrated here - that said, also my reminder here that the timezone belongs to the city table the country table! - but I dont know how rich he wants his database here.. So maybe you have to do it yourself