Search results
TimeZoneDB provides free time zone database for cities of the world. The database is licensed under Creative Commons Attribution 3.0 License. It contains countries name, time zones, abbreviation, GMT offset, and Daylight Saving Time (DST). The data is available in CSV and SQL format.
- API
You need to register a free API key to start using our...
- Premium
Premium - Free Time Zone Database & API - TimeZoneDB
- Download
The example below showing how to query the time zone...
- Status
Status - Free Time Zone Database & API - TimeZoneDB
- Contact
Contact - Free Time Zone Database & API - TimeZoneDB
- Register
Register a TimeZoneDB account for free access to timezone...
- About
About. TimeZoneDB website is managed by a web developer...
- Forgot Password
Download; Status; Contact; Forgot Password. If you lost your...
- API
Download a free list of ZIP codes in Excel/CSV/spreadsheet format including state, city, county, area code, latitude, longitude, and more.
Here's a list of zip code ranges per state, and a list of states per time zone. You can see the boundaries of zip codes and compare to the timezone map using this link, or Google Earth, to map zips to time zones for the states that are split by a time zone line.
The complete list of ZIP codes that cross state lines is available as part of our US ZIP code list. It gets even more complicated when trying to assign a ZIP code to a specific county (as much as 25% cross county lines), congressional district, metro area, time zone, area code, etc.
5 sty 2024 · Best Game Torrent Sites. 1. FitGirl Repacks (Compressed Games For Quick Download) First, on the Best Game Download Torrent Sites list, we have the tried and trusted FitGirl Repacks. As the name suggests, you can effortlessly download repacked games from FitGirl Repacks even if you have slow download speeds.
4 kwi 2024 · The example below showing how to query the time zone information using zone name America/Los_Angeles. SELECT `country_code`, `zone_name`, `abbreviation`, `gmt_offset`, `dst` FROM `time_zone` WHERE `time_start` = UNIX_TIMESTAMP(UTC_TIMESTAMP()) AND `zone_name` = 'America/Los_Angeles' ORDER BY `time_start` DESC LIMIT 1;
The complete list and database of 5-digit US zip codes is available for download in CSV , SQL , XML , YAML , HTML , PDF, and MS Excel formats. Number of Zip Codes: 41,705. List Updated On: December 2022.