IP2Location™ Olson Time Zone

For customer only

IP2Location™ Olson Time Zone, or tz data, is a free data offered for our valued customer. This data enables you to retrieve the Olson Time Zone value of a given city name. And, this piece of information is very useful if you need it for web display, dropdown box selection or other coding requirements.

Product Features

Last Update	06/29/2017
Database Format	CSV Text File (Comma Delimited)

Database Fields

Name	Type	Description
country_code	CHAR(2)	Two-character country code based on ISO 3166.
region_name	VARCHAR(128)	Region or state name.
city_name	VARCHAR(128)	City name.
olson_tz	VARCHAR(30)	Olson time zone.

MySQL Statement

CREATE TABLE `ip2location_olson_timezone`(
	`country_code` CHAR(2),
	`region_name` VARCHAR(128),
	`city_name` VARCHAR(128),
	`olson_tz` VARCHAR(30),
	INDEX `idx_country_code` (`country_code`),
	INDEX `idx_region_name` (`region_name`),
	INDEX `idx_city_name` (`city_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-OLSON-TIMEZONE.CSV' INTO TABLE `ip2location_olson_timezone`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

License Information

IP2Location™ is a registered trademark of HEXASOFT. All other trademarks are the property of their respective owners.

Thank you for downloading

Sharing this great stuff to your friends!

Or share it on your blog or web page:

								Free IP2Location geolocation resources available at <a href="http://www.ip2location.com">http://www.ip2location.com</a>
							

Copy & paste this text as HTML.

IP2Location Databases

IP2Location™ Olson Time Zone

MySQL Statement