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
6.81k stars 2.44k forks source link

Timezones is missing for Czech Republic in sql/countries.sql #794

Open apfromiit opened 3 days ago

apfromiit commented 3 days ago
Screenshot 2024-06-29 at 3 08 59 PM
dosubot[bot] commented 3 days ago

Hey @apfromiit! I'm here to help you with any bugs, questions, or contributions you have. Let's tackle this together!

The correct timezone information for the Czech Republic that should be included in the sql/countries.sql file is:

'[{\"zoneName\":\"Europe/Prague\",\"gmtOffset\":3600,\"gmtOffsetName\":\"UTC+01:00\",\"abbreviation\":\"CET\",\"tzName\":\"Central European Time\"}]'

This can be added to the existing entry for the Czech Republic in the sql/countries.sql file [1].

To continue talking to Dosu, mention @dosu.