List of Timezone GMT Database Query Mysql
Hi Today Discussed List of Timezone GMT Database Query Mysql normally php mysql basic database country timezone and state city this basic normally database stored so timezone database followes queries.
Hi Today Discussed List of Timezone GMT Database Query Mysql normally php mysql basic database country timezone and state city this basic normally database stored so timezone database followes queries.
 |
| List of Timezone GMT Database Query Mysql |
CREATE TABLE `zone` (
`id` int(11) NOT NULL,
`country_code` varchar(255) NOT NULL,
`zone_name` text NOT NULL,
`status` int(11) NOT NULL COMMENT '0-inactive 1-active'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Database Value
INSERT INTO `zone` (`id`, `country_code`, `zone_name`, `status`) VALUES
(1, 'Pacific/Kwajalein', '(GMT -12:00) Eniwetok, Kwajalein', 0),
(2, 'Pacific/Samoa', '(GMT -11:00) Midway Island, Samoa', 0),
(3, 'Pacific/Honolulu', '(GMT -10:00) Hawaii', 0),
(4, 'America/Anchorage', '(GMT -9:00) Alaska', 0),
(5, 'America/Los_Angeles', '(GMT -8:00) Pacific Time (US & Canada) Los Angeles, Seattle', 0),
(6, 'America/Denver', '(GMT -7:00) Mountain Time (US & Canada) Denver', 0),
(7, 'America/Chicago', '(GMT -6:00) Central Time (US & Canada), Chicago, Mexico City', 0),
(8, 'America/New_York', '(GMT -5:00) Eastern Time (US & Canada), New York, Bogota, Lima', 0),
(9, 'Atlantic/Bermuda', '(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz', 0),
(10, 'Canada/Newfoundland', '(GMT -3:30) Newfoundland', 0),
(11, 'Brazil/East', '(GMT -3:00) Brazil, Buenos Aires, Georgetown', 0),
(12, 'Atlantic/Azores', '(GMT -2:00) Mid-Atlantic', 0),
(13, 'Atlantic/Cape_Verde', '(GMT -1:00 hour) Azores, Cape Verde Islands', 0),
(14, 'Europe/London', '(GMT) Western Europe Time, London, Lisbon, Casablanca', 0),
(15, 'Europe/Brussels', '(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris', 0),
(16, 'Europe/Helsinki', '(GMT +2:00) Kaliningrad, South Africa', 0),
(17, 'Asia/Baghdad', '(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg', 0),
(18, 'Asia/Tehran', '(GMT +3:30) Tehran', 0),
(19, 'Asia/Baku', '(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi', 0),
(20, 'Asia/Kabul', '(GMT +4:30) Kabul', 0),
(21, 'Asia/Karachi', '(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent', 1),
(22, 'Asia/Calcutta', '(GMT +5:30) Bombay, Calcutta, Madras, New Delhi', 0),
(23, 'Asia/Dhaka', '(GMT +6:00) Almaty, Dhaka, Colombo', 0),
(24, 'Asia/Bangkok', '(GMT +7:00) Bangkok, Hanoi, Jakarta', 0),
(25, 'Asia/Hong_Kong', '(GMT +8:00) Beijing, Perth, Singapore, Hong Kong', 0),
(26, 'Asia/Tokyo', '(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk', 0),
(27, 'Australia/Adelaide', '(GMT +9:30) Adelaide, Darwin', 0),
(28, 'Pacific/Guam', '(GMT +10:00) Eastern Australia, Guam, Vladivostok', 0),
(29, 'Asia/Magadan', '(GMT +11:00) Magadan, Solomon Islands, New Caledonia', 0),
(30, 'Pacific/Fiji', '(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka', 0);