Convert GMT/UTC to Local datetime

,

Almost all applications enable for internationalization save the datetime columns in UTC/GMT time zones and present converted datetime to local time zones based on users time zone preferences.

Sql server at present does not have any build in functions to be able to do this. To do this type of datetime conversion you need to have all the offset information and the daylight saving information for the timezones. This can be in form of a table where you save timezone and offset with GMT and daylight savings start and end time. There are few changes to the daylight savings after Energy Policy Act 2005. So you need to consider those and any other changes as well. I bumped into this problem once and here is how I solved it.

This script includes a SQL function dbo.get_local_datetime (datetime, time_zone) to convert GMT based datetime values in the database to local timezone. SQL Function relies on a table containing time zone offsets by time zone ids. The table is created and populated by timezone_offsets.sql.

There are different opinions on how many time zones a business application should offer. For example, Microsoft Windows lists all of the major time zones, which is about 74 of them. While this is set as a standard by Microsoft, many applications need to support subsets of these time zones. Java covers a wide range of time zone subsets based on major cities over the globe.

This table generated by timezone_offsets.sql covers 599 subsets of all the timezones supported by JDK 6.0. You may require to have data for many more years then what I have given in the script. Due to script size limitation I've added timezone information only for year 2009. You can use a jar application at https://www.codeproject.com/Articles/34133/Convert-GMT-to-Local-Date-time to generate timezone offset info for years. So if next java version adds 200 more sub time zones all you need to do is re-generate this script.

SET NOCOUNT ON

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 2009-03-14, Ritesh Poojara; riteshpoojara@yahoo.com 
-- This script stores time zone offset changes info from 2009 to 2009 for all the availale timezones in Java,
-- this information is generated by timeZoneOffsets.jar. The SQL function takes care of of any changes made to the Daylight
-- savings since Energy Policy Act (EPAct) of 2005 or any other changes made earlier
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-- create table if not exists
if (exists (select 1 from dbo.sysobjects where xtype = 'U' and name = 'timezone_offsets'))
begin
    drop table dbo.timezone_offsets
end

CREATE TABLE dbo.timezone_offsets (
  time_zone_id   VARCHAR(50)   NOT NULL,
  start_time_gmt DATETIME   NOT NULL,
  end_time_gmt   DATETIME   NOT NULL,
  offset         NUMERIC(18,0)   NOT NULL)

GO 
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+12','2009-01-01 00:00:00','2010-01-01 00:00:59',-43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+11','2009-01-01 00:00:00','2010-01-01 00:00:59',-39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('MIT','2009-01-01 00:00:00','2010-01-01 00:00:59',-39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Apia','2009-01-01 00:00:00','2010-01-01 00:00:59',-39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Midway','2009-01-01 00:00:00','2010-01-01 00:00:59',-39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Niue','2009-01-01 00:00:00','2010-01-01 00:00:59',-39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Pago_Pago','2009-01-01 00:00:00','2010-01-01 00:00:59',-39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Samoa','2009-01-01 00:00:00','2010-01-01 00:00:59',-39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Samoa','2009-01-01 00:00:00','2010-01-01 00:00:59',-39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+10','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('HST','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Fakaofo','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Honolulu','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Johnston','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Rarotonga','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Tahiti','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/HST10','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Hawaii','2009-01-01 00:00:00','2010-01-01 00:00:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Marquesas','2009-01-01 00:00:00','2010-01-01 00:00:59',-34200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+9','2009-01-01 00:00:00','2010-01-01 00:00:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Gambier','2009-01-01 00:00:00','2010-01-01 00:00:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/YST9','2009-01-01 00:00:00','2010-01-01 00:00:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+8','2009-01-01 00:00:00','2010-01-01 00:00:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Pitcairn','2009-01-01 00:00:00','2010-01-01 00:00:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/PST8','2009-01-01 00:00:00','2010-01-01 00:00:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Dawson_Creek','2009-01-01 00:00:00','2010-01-01 00:00:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Hermosillo','2009-01-01 00:00:00','2010-01-01 00:00:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Phoenix','2009-01-01 00:00:00','2010-01-01 00:00:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+7','2009-01-01 00:00:00','2010-01-01 00:00:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('MST','2009-01-01 00:00:00','2010-01-01 00:00:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('PNT','2009-01-01 00:00:00','2010-01-01 00:00:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/MST7','2009-01-01 00:00:00','2010-01-01 00:00:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Arizona','2009-01-01 00:00:00','2010-01-01 00:00:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Belize','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Costa_Rica','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/El_Salvador','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Guatemala','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Managua','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Regina','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Swift_Current','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Tegucigalpa','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/East-Saskatchewan','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Saskatchewan','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+6','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Galapagos','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/CST6','2009-01-01 00:00:00','2010-01-01 00:00:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Atikokan','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Bogota','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cayman','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Coral_Harbour','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Guayaquil','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Jamaica','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Lima','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Panama','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Port-au-Prince','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Resolute','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('EST','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+5','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Jamaica','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/EST5','2009-01-01 00:00:00','2010-01-01 00:00:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Caracas','2009-01-01 00:00:00','2010-01-01 00:00:59',-16200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Anguilla','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Antigua','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Aruba','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Barbados','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Blanc-Sablon','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Boa_Vista','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Curacao','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Dominica','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Eirunepe','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Grenada','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Guadeloupe','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Guyana','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/La_Paz','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Manaus','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Marigot','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Martinique','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Montserrat','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Port_of_Spain','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Porto_Acre','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Porto_Velho','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Puerto_Rico','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Rio_Branco','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Santo_Domingo','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/St_Barthelemy','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/St_Kitts','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/St_Lucia','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/St_Thomas','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/St_Vincent','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Tortola','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Virgin','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Brazil/Acre','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Brazil/West','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+4','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('PRT','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/AST4','2009-01-01 00:00:00','2010-01-01 00:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Araguaina','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Catamarca','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/ComodRivadavia','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Jujuy','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/La_Rioja','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Mendoza','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Rio_Gallegos','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Salta','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/San_Juan','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/San_Luis','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Ushuaia','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Bahia','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Belem','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Catamarca','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cayenne','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Fortaleza','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Jujuy','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Maceio','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Mendoza','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Paramaribo','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Recife','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Santarem','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/Rothera','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+3','2009-01-01 00:00:00','2010-01-01 00:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Noronha','2009-01-01 00:00:00','2010-01-01 00:00:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/South_Georgia','2009-01-01 00:00:00','2010-01-01 00:00:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Brazil/DeNoronha','2009-01-01 00:00:00','2010-01-01 00:00:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+2','2009-01-01 00:00:00','2010-01-01 00:00:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Cape_Verde','2009-01-01 00:00:00','2010-01-01 00:00:59',-3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+1','2009-01-01 00:00:00','2010-01-01 00:00:59',-3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Abidjan','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Accra','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Bamako','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Banjul','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Bissau','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Casablanca','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Conakry','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Dakar','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/El_Aaiun','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Freetown','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Lome','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Monrovia','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Nouakchott','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Ouagadougou','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Sao_Tome','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Timbuktu','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Danmarkshavn','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Reykjavik','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/St_Helena','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT+0','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-0','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT0','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/Greenwich','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/UCT','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/UTC','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/Universal','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/Zulu','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('GMT','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('GMT0','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Greenwich','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Iceland','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('UCT','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('UTC','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Universal','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Zulu','2009-01-01 00:00:00','2010-01-01 00:00:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Algiers','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Bangui','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Brazzaville','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Douala','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Kinshasa','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Lagos','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Libreville','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Luanda','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Malabo','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Ndjamena','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Niamey','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Porto-Novo','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-1','2009-01-01 00:00:00','2010-01-01 00:00:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Blantyre','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Bujumbura','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Gaborone','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Harare','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Johannesburg','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Kigali','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Lubumbashi','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Lusaka','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Maputo','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Maseru','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Mbabane','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Tripoli','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CAT','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-2','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Libya','2009-01-01 00:00:00','2010-01-01 00:00:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Addis_Ababa','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Asmara','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Asmera','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Dar_es_Salaam','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Djibouti','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Kampala','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Khartoum','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Mogadishu','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Nairobi','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/Syowa','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Aden','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Baghdad','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Bahrain','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Kuwait','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Qatar','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Riyadh','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('EAT','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-3','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Antananarivo','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Comoro','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Mayotte','2009-01-01 00:00:00','2010-01-01 00:00:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Riyadh87','2009-01-01 00:00:00','2010-01-01 00:00:59',11224000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Riyadh88','2009-01-01 00:00:00','2010-01-01 00:00:59',11224000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Riyadh89','2009-01-01 00:00:00','2010-01-01 00:00:59',11224000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mideast/Riyadh87','2009-01-01 00:00:00','2010-01-01 00:00:59',11224000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mideast/Riyadh88','2009-01-01 00:00:00','2010-01-01 00:00:59',11224000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mideast/Riyadh89','2009-01-01 00:00:00','2010-01-01 00:00:59',11224000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Dubai','2009-01-01 00:00:00','2010-01-01 00:00:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Muscat','2009-01-01 00:00:00','2010-01-01 00:00:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Tbilisi','2009-01-01 00:00:00','2010-01-01 00:00:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-4','2009-01-01 00:00:00','2010-01-01 00:00:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Mahe','2009-01-01 00:00:00','2010-01-01 00:00:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Reunion','2009-01-01 00:00:00','2010-01-01 00:00:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Kabul','2009-01-01 00:00:00','2010-01-01 00:00:59',16200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Aqtau','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Aqtobe','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Ashgabat','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Ashkhabad','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Dushanbe','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Karachi','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Oral','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Samarkand','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Tashkent','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-5','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Kerguelen','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Maldives','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('PLT','2009-01-01 00:00:00','2010-01-01 00:00:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Calcutta','2009-01-01 00:00:00','2010-01-01 00:00:59',19800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Colombo','2009-01-01 00:00:00','2010-01-01 00:00:59',19800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Kolkata','2009-01-01 00:00:00','2010-01-01 00:00:59',19800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('IST','2009-01-01 00:00:00','2010-01-01 00:00:59',19800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Katmandu','2009-01-01 00:00:00','2010-01-01 00:00:59',20700000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/Mawson','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/Vostok','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Almaty','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Bishkek','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Dacca','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Dhaka','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Qyzylorda','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Thimbu','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Thimphu','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('BST','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-6','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Chagos','2009-01-01 00:00:00','2010-01-01 00:00:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Rangoon','2009-01-01 00:00:00','2010-01-01 00:00:59',23400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Cocos','2009-01-01 00:00:00','2010-01-01 00:00:59',23400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/Davis','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Bangkok','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Ho_Chi_Minh','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Hovd','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Jakarta','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Phnom_Penh','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Pontianak','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Saigon','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Vientiane','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-7','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Christmas','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('VST','2009-01-01 00:00:00','2010-01-01 00:00:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/Casey','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Brunei','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Choibalsan','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Chongqing','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Chungking','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Harbin','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Hong_Kong','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Kashgar','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Kuala_Lumpur','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Kuching','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Macao','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Macau','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Makassar','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Manila','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Shanghai','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Singapore','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Taipei','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Ujung_Pandang','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Ulaanbaatar','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Ulan_Bator','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Urumqi','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Perth','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/West','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CTT','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-8','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Hongkong','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('PRC','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Singapore','2009-01-01 00:00:00','2010-01-01 00:00:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Eucla','2009-01-01 00:00:00','2010-01-01 00:00:59',31500000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Dili','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Jayapura','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Pyongyang','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Seoul','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Tokyo','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-9','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('JST','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Japan','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Palau','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('ROK','2009-01-01 00:00:00','2010-01-01 00:00:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('ACT','2009-01-01 00:00:00','2010-01-01 00:00:59',34200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Darwin','2009-01-01 00:00:00','2010-01-01 00:00:59',34200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/North','2009-01-01 00:00:00','2010-01-01 00:00:59',34200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/DumontDUrville','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Brisbane','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Lindeman','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Queensland','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-10','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Guam','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Port_Moresby','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Saipan','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Truk','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Yap','2009-01-01 00:00:00','2010-01-01 00:00:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-11','2009-01-01 00:00:00','2010-01-01 00:00:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Efate','2009-01-01 00:00:00','2010-01-01 00:00:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Guadalcanal','2009-01-01 00:00:00','2010-01-01 00:00:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Kosrae','2009-01-01 00:00:00','2010-01-01 00:00:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Noumea','2009-01-01 00:00:00','2010-01-01 00:00:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Ponape','2009-01-01 00:00:00','2010-01-01 00:00:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SST','2009-01-01 00:00:00','2010-01-01 00:00:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Norfolk','2009-01-01 00:00:00','2010-01-01 00:00:59',41400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-12','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Kwajalein','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Fiji','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Funafuti','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Kwajalein','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Majuro','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Nauru','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Tarawa','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Wake','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Wallis','2009-01-01 00:00:00','2010-01-01 00:00:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-13','2009-01-01 00:00:00','2010-01-01 00:00:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Enderbury','2009-01-01 00:00:00','2010-01-01 00:00:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Tongatapu','2009-01-01 00:00:00','2010-01-01 00:00:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Etc/GMT-14','2009-01-01 00:00:00','2010-01-01 00:00:59',50400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Kiritimati','2009-01-01 00:00:00','2010-01-01 00:00:59',50400000)
 
GO 
 
--Time zones implementing Daylight savings 
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Adak','2009-01-01 00:00:00','2009-03-08 11:59:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Adak','2009-03-08 12:00:00','2009-11-01 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Atka','2009-01-01 00:00:00','2009-03-08 11:59:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Atka','2009-03-08 12:00:00','2009-11-01 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Aleutian','2009-01-01 00:00:00','2009-03-08 11:59:59',-36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Aleutian','2009-03-08 12:00:00','2009-11-01 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('AST','2009-01-01 00:00:00','2009-03-08 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('AST','2009-03-08 11:00:00','2009-11-01 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Anchorage','2009-01-01 00:00:00','2009-03-08 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Anchorage','2009-03-08 11:00:00','2009-11-01 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Juneau','2009-01-01 00:00:00','2009-03-08 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Juneau','2009-03-08 11:00:00','2009-11-01 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Nome','2009-01-01 00:00:00','2009-03-08 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Nome','2009-03-08 11:00:00','2009-11-01 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Yakutat','2009-01-01 00:00:00','2009-03-08 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Yakutat','2009-03-08 11:00:00','2009-11-01 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/YST9YDT','2009-01-01 00:00:00','2009-04-26 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/YST9YDT','2009-04-26 11:00:00','2009-10-25 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Alaska','2009-01-01 00:00:00','2009-03-08 10:59:59',-32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Alaska','2009-03-08 11:00:00','2009-11-01 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Dawson','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Dawson','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Ensenada','2009-01-01 00:00:00','2009-04-05 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Ensenada','2009-04-05 10:00:00','2009-10-25 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Los_Angeles','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Los_Angeles','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Tijuana','2009-01-01 00:00:00','2009-04-05 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Tijuana','2009-04-05 10:00:00','2009-10-25 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Vancouver','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Vancouver','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Whitehorse','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Whitehorse','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Pacific','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Pacific','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Yukon','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Yukon','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mexico/BajaNorte','2009-01-01 00:00:00','2009-04-05 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mexico/BajaNorte','2009-04-05 10:00:00','2009-10-25 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('PST','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('PST','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('PST8PDT','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('PST8PDT','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/PST8PDT','2009-01-01 00:00:00','2009-04-26 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/PST8PDT','2009-04-26 10:00:00','2009-10-25 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Pacific','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Pacific','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Pacific-New','2009-01-01 00:00:00','2009-03-08 09:59:59',-28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Pacific-New','2009-03-08 10:00:00','2009-11-01 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Boise','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Boise','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cambridge_Bay','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cambridge_Bay','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Chihuahua','2009-01-01 00:00:00','2009-04-05 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Chihuahua','2009-04-05 09:00:00','2009-10-25 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Denver','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Denver','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Edmonton','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Edmonton','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Inuvik','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Inuvik','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Mazatlan','2009-01-01 00:00:00','2009-04-05 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Mazatlan','2009-04-05 09:00:00','2009-10-25 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Shiprock','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Shiprock','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Yellowknife','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Yellowknife','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Mountain','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Mountain','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('MST7MDT','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('MST7MDT','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mexico/BajaSur','2009-01-01 00:00:00','2009-04-05 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mexico/BajaSur','2009-04-05 09:00:00','2009-10-25 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Navajo','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Navajo','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/MST7MDT','2009-01-01 00:00:00','2009-04-26 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/MST7MDT','2009-04-26 09:00:00','2009-10-25 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Mountain','2009-01-01 00:00:00','2009-03-08 08:59:59',-25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Mountain','2009-03-08 09:00:00','2009-11-01 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cancun','2009-01-01 00:00:00','2009-04-05 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cancun','2009-04-05 08:00:00','2009-10-25 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Chicago','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Chicago','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Knox','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Knox','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Tell_City','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Tell_City','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Knox_IN','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Knox_IN','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Menominee','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Menominee','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Merida','2009-01-01 00:00:00','2009-04-05 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Merida','2009-04-05 08:00:00','2009-10-25 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Mexico_City','2009-01-01 00:00:00','2009-04-05 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Mexico_City','2009-04-05 08:00:00','2009-10-25 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Monterrey','2009-01-01 00:00:00','2009-04-05 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Monterrey','2009-04-05 08:00:00','2009-10-25 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/North_Dakota/Center','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/North_Dakota/Center','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/North_Dakota/New_Salem','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/North_Dakota/New_Salem','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Rainy_River','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Rainy_River','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Rankin_Inlet','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Rankin_Inlet','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Winnipeg','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Winnipeg','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CST','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CST','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CST6CDT','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CST6CDT','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Central','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Central','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Chile/EasterIsland','2009-01-01 00:00:00','2009-03-15 02:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Chile/EasterIsland','2009-03-15 03:00:00','2009-10-11 03:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mexico/General','2009-01-01 00:00:00','2009-04-05 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Mexico/General','2009-04-05 08:00:00','2009-10-25 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Easter','2009-01-01 00:00:00','2009-03-15 02:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Easter','2009-03-15 03:00:00','2009-10-11 03:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/CST6CDT','2009-01-01 00:00:00','2009-04-26 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/CST6CDT','2009-04-26 08:00:00','2009-10-25 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Central','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Central','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Indiana-Starke','2009-01-01 00:00:00','2009-03-08 07:59:59',-21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Indiana-Starke','2009-03-08 08:00:00','2009-11-01 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Detroit','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Detroit','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Fort_Wayne','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Fort_Wayne','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Grand_Turk','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Grand_Turk','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Havana','2009-01-01 00:00:00','2009-03-15 04:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Havana','2009-03-15 05:00:00','2009-10-25 04:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Indianapolis','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Indianapolis','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Marengo','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Marengo','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Petersburg','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Petersburg','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Vevay','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Vevay','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Vincennes','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Vincennes','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Winamac','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indiana/Winamac','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indianapolis','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Indianapolis','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Iqaluit','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Iqaluit','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Kentucky/Louisville','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Kentucky/Louisville','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Kentucky/Monticello','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Kentucky/Monticello','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Louisville','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Louisville','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Montreal','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Montreal','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Nassau','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Nassau','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/New_York','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/New_York','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Nipigon','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Nipigon','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Pangnirtung','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Pangnirtung','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Thunder_Bay','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Thunder_Bay','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Toronto','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Toronto','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Eastern','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Eastern','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Cuba','2009-01-01 00:00:00','2009-03-15 04:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Cuba','2009-03-15 05:00:00','2009-10-25 04:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('EST5EDT','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('EST5EDT','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('IET','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('IET','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/EST5EDT','2009-01-01 00:00:00','2009-04-26 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/EST5EDT','2009-04-26 07:00:00','2009-10-25 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/East-Indiana','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/East-Indiana','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Eastern','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Eastern','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Michigan','2009-01-01 00:00:00','2009-03-08 06:59:59',-18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('US/Michigan','2009-03-08 07:00:00','2009-11-01 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Asuncion','2009-01-01 00:00:00','2009-03-08 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Asuncion','2009-03-08 03:00:00','2009-10-18 03:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Campo_Grande','2009-01-01 00:00:00','2009-02-15 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Campo_Grande','2009-02-15 03:00:00','2009-10-18 03:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cuiaba','2009-01-01 00:00:00','2009-02-15 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cuiaba','2009-02-15 03:00:00','2009-10-18 03:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Glace_Bay','2009-01-01 00:00:00','2009-03-08 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Glace_Bay','2009-03-08 06:00:00','2009-11-01 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Goose_Bay','2009-01-01 00:00:00','2009-03-08 04:00:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Goose_Bay','2009-03-08 04:01:00','2009-11-01 03:00:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Halifax','2009-01-01 00:00:00','2009-03-08 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Halifax','2009-03-08 06:00:00','2009-11-01 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Moncton','2009-01-01 00:00:00','2009-03-08 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Moncton','2009-03-08 06:00:00','2009-11-01 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Santiago','2009-01-01 00:00:00','2009-03-15 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Santiago','2009-03-15 03:00:00','2009-10-11 03:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Thule','2009-01-01 00:00:00','2009-03-08 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Thule','2009-03-08 06:00:00','2009-11-01 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/Palmer','2009-01-01 00:00:00','2009-03-15 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/Palmer','2009-03-15 03:00:00','2009-10-11 03:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Bermuda','2009-01-01 00:00:00','2009-03-08 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Bermuda','2009-03-08 06:00:00','2009-11-01 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Stanley','2009-01-01 00:00:00','2009-04-19 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Stanley','2009-04-19 05:00:00','2009-09-06 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Atlantic','2009-01-01 00:00:00','2009-03-08 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Atlantic','2009-03-08 06:00:00','2009-11-01 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Chile/Continental','2009-01-01 00:00:00','2009-03-15 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Chile/Continental','2009-03-15 03:00:00','2009-10-11 03:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/AST4ADT','2009-01-01 00:00:00','2009-04-26 05:59:59',-14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('SystemV/AST4ADT','2009-04-26 06:00:00','2009-10-25 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/St_Johns','2009-01-01 00:00:00','2009-03-08 03:30:59',-12600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/St_Johns','2009-03-08 03:31:00','2009-11-01 02:30:59',-9000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CNT','2009-01-01 00:00:00','2009-03-08 03:30:59',-12600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CNT','2009-03-08 03:31:00','2009-11-01 02:30:59',-9000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Newfoundland','2009-01-01 00:00:00','2009-03-08 03:30:59',-12600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Canada/Newfoundland','2009-03-08 03:31:00','2009-11-01 02:30:59',-9000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('AGT','2009-01-01 00:00:00','2009-03-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('AGT','2009-03-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Buenos_Aires','2009-01-01 00:00:00','2009-03-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Buenos_Aires','2009-03-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Cordoba','2009-01-01 00:00:00','2009-03-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Cordoba','2009-03-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Tucuman','2009-01-01 00:00:00','2009-03-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Argentina/Tucuman','2009-03-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Buenos_Aires','2009-01-01 00:00:00','2009-03-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Buenos_Aires','2009-03-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cordoba','2009-01-01 00:00:00','2009-03-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Cordoba','2009-03-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Godthab','2009-01-01 00:00:00','2009-03-29 00:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Godthab','2009-03-29 01:00:00','2009-10-25 00:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Miquelon','2009-01-01 00:00:00','2009-03-08 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Miquelon','2009-03-08 05:00:00','2009-11-01 03:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Montevideo','2009-01-01 00:00:00','2009-03-08 03:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Montevideo','2009-03-08 04:00:00','2009-10-04 04:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Rosario','2009-01-01 00:00:00','2009-03-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Rosario','2009-03-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Sao_Paulo','2009-01-01 00:00:00','2009-02-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Sao_Paulo','2009-02-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('BET','2009-01-01 00:00:00','2009-02-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('BET','2009-02-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Brazil/East','2009-01-01 00:00:00','2009-02-15 01:59:59',-7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Brazil/East','2009-02-15 02:00:00','2009-10-18 02:59:59',-10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Scoresbysund','2009-01-01 00:00:00','2009-03-29 00:59:59',-3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('America/Scoresbysund','2009-03-29 01:00:00','2009-10-25 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Azores','2009-01-01 00:00:00','2009-03-29 00:59:59',-3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Azores','2009-03-29 01:00:00','2009-10-25 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Canary','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Canary','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Faeroe','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Faeroe','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Faroe','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Faroe','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Madeira','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Madeira','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Eire','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Eire','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Belfast','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Belfast','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Dublin','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Dublin','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Guernsey','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Guernsey','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Isle_of_Man','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Isle_of_Man','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Jersey','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Jersey','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Lisbon','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Lisbon','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/London','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/London','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('GB','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('GB','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('GB-Eire','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('GB-Eire','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Portugal','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Portugal','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('WET','2009-01-01 00:00:00','2009-03-29 00:59:59',0)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('WET','2009-03-29 01:00:00','2009-10-25 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Ceuta','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Ceuta','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Tunis','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Tunis','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Windhoek','2009-01-01 00:00:00','2009-04-04 23:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Windhoek','2009-04-05 00:00:00','2009-09-06 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Arctic/Longyearbyen','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Arctic/Longyearbyen','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Jan_Mayen','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Atlantic/Jan_Mayen','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CET','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('CET','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('ECT','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('ECT','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Amsterdam','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Amsterdam','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Andorra','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Andorra','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Belgrade','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Belgrade','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Berlin','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Berlin','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Bratislava','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Bratislava','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Brussels','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Brussels','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Budapest','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Budapest','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Copenhagen','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Copenhagen','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Gibraltar','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Gibraltar','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Ljubljana','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Ljubljana','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Luxembourg','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Luxembourg','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Madrid','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Madrid','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Malta','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Malta','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Monaco','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Monaco','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Oslo','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Oslo','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Paris','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Paris','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Podgorica','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Podgorica','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Prague','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Prague','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Rome','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Rome','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/San_Marino','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/San_Marino','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Sarajevo','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Sarajevo','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Skopje','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Skopje','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Stockholm','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Stockholm','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Tirane','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Tirane','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Vaduz','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Vaduz','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Vatican','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Vatican','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Vienna','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Vienna','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Warsaw','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Warsaw','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Zagreb','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Zagreb','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Zurich','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Zurich','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('MET','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('MET','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Poland','2009-01-01 00:00:00','2009-03-29 00:59:59',3600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Poland','2009-03-29 01:00:00','2009-10-25 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('ART','2009-01-01 00:00:00','2009-04-23 21:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('ART','2009-04-23 22:00:00','2009-08-27 20:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Cairo','2009-01-01 00:00:00','2009-04-23 21:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Africa/Cairo','2009-04-23 22:00:00','2009-08-27 20:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Amman','2009-01-01 00:00:00','2009-03-25 21:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Amman','2009-03-25 22:00:00','2009-10-29 21:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Beirut','2009-01-01 00:00:00','2009-03-28 21:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Beirut','2009-03-28 22:00:00','2009-10-24 20:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Damascus','2009-01-01 00:00:00','2009-04-02 21:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Damascus','2009-04-02 22:00:00','2009-10-31 20:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Gaza','2009-01-01 00:00:00','2009-03-31 21:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Gaza','2009-03-31 22:00:00','2009-08-26 22:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Istanbul','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Istanbul','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Jerusalem','2009-01-01 00:00:00','2009-03-26 23:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Jerusalem','2009-03-27 00:00:00','2009-09-26 22:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Nicosia','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Nicosia','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Tel_Aviv','2009-01-01 00:00:00','2009-03-26 23:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Tel_Aviv','2009-03-27 00:00:00','2009-09-26 22:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('EET','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('EET','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Egypt','2009-01-01 00:00:00','2009-04-23 21:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Egypt','2009-04-23 22:00:00','2009-08-27 20:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Athens','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Athens','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Bucharest','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Bucharest','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Chisinau','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Chisinau','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Helsinki','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Helsinki','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Istanbul','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Istanbul','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Kaliningrad','2009-01-01 00:00:00','2009-03-28 23:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Kaliningrad','2009-03-29 00:00:00','2009-10-24 23:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Kiev','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Kiev','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Mariehamn','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Mariehamn','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Minsk','2009-01-01 00:00:00','2009-03-28 23:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Minsk','2009-03-29 00:00:00','2009-10-24 23:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Nicosia','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Nicosia','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Riga','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Riga','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Simferopol','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Simferopol','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Sofia','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Sofia','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Tallinn','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Tallinn','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Tiraspol','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Tiraspol','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Uzhgorod','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Uzhgorod','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Vilnius','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Vilnius','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Zaporozhye','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Zaporozhye','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Israel','2009-01-01 00:00:00','2009-03-26 23:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Israel','2009-03-27 00:00:00','2009-09-26 22:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Turkey','2009-01-01 00:00:00','2009-03-29 00:59:59',7200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Turkey','2009-03-29 01:00:00','2009-10-25 00:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Moscow','2009-01-01 00:00:00','2009-03-28 22:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Moscow','2009-03-28 23:00:00','2009-10-24 22:59:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Volgograd','2009-01-01 00:00:00','2009-03-28 22:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Volgograd','2009-03-28 23:00:00','2009-10-24 22:59:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('W-SU','2009-01-01 00:00:00','2009-03-28 22:59:59',10800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('W-SU','2009-03-28 23:00:00','2009-10-24 22:59:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Tehran','2009-01-01 00:00:00','2009-03-21 20:29:59',12600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Tehran','2009-03-21 20:30:00','2009-09-21 19:29:59',16200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Iran','2009-01-01 00:00:00','2009-03-21 20:29:59',12600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Iran','2009-03-21 20:30:00','2009-09-21 19:29:59',16200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Baku','2009-01-01 00:00:00','2009-03-28 23:59:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Baku','2009-03-29 00:00:00','2009-10-24 23:59:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Yerevan','2009-01-01 00:00:00','2009-03-28 21:59:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Yerevan','2009-03-28 22:00:00','2009-10-24 21:59:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Samara','2009-01-01 00:00:00','2009-03-28 21:59:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Europe/Samara','2009-03-28 22:00:00','2009-10-24 21:59:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Mauritius','2009-01-01 00:00:00','2009-03-28 21:59:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Indian/Mauritius','2009-03-28 22:00:00','2009-10-24 21:59:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('NET','2009-01-01 00:00:00','2009-03-28 21:59:59',14400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('NET','2009-03-28 22:00:00','2009-10-24 21:59:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Yekaterinburg','2009-01-01 00:00:00','2009-03-28 20:59:59',18000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Yekaterinburg','2009-03-28 21:00:00','2009-10-24 20:59:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Novosibirsk','2009-01-01 00:00:00','2009-03-28 19:59:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Novosibirsk','2009-03-28 20:00:00','2009-10-24 19:59:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Omsk','2009-01-01 00:00:00','2009-03-28 19:59:59',21600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Omsk','2009-03-28 20:00:00','2009-10-24 19:59:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Krasnoyarsk','2009-01-01 00:00:00','2009-03-28 18:59:59',25200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Krasnoyarsk','2009-03-28 19:00:00','2009-10-24 18:59:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Irkutsk','2009-01-01 00:00:00','2009-03-28 17:59:59',28800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Irkutsk','2009-03-28 18:00:00','2009-10-24 17:59:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Yakutsk','2009-01-01 00:00:00','2009-03-28 16:59:59',32400000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Yakutsk','2009-03-28 17:00:00','2009-10-24 16:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Adelaide','2009-01-01 00:00:00','2009-04-04 16:29:59',37800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Adelaide','2009-04-04 16:30:00','2009-10-03 16:29:59',34200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Broken_Hill','2009-01-01 00:00:00','2009-04-04 16:29:59',37800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Broken_Hill','2009-04-04 16:30:00','2009-10-03 16:29:59',34200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/South','2009-01-01 00:00:00','2009-04-04 16:29:59',37800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/South','2009-04-04 16:30:00','2009-10-03 16:29:59',34200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Yancowinna','2009-01-01 00:00:00','2009-04-04 16:29:59',37800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Yancowinna','2009-04-04 16:30:00','2009-10-03 16:29:59',34200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('AET','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('AET','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Sakhalin','2009-01-01 00:00:00','2009-03-28 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Sakhalin','2009-03-28 16:00:00','2009-10-24 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Vladivostok','2009-01-01 00:00:00','2009-03-28 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Vladivostok','2009-03-28 16:00:00','2009-10-24 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/ACT','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/ACT','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Canberra','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Canberra','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Currie','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Currie','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Hobart','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Hobart','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Melbourne','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Melbourne','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/NSW','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/NSW','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Sydney','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Sydney','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Tasmania','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Tasmania','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Victoria','2009-01-01 00:00:00','2009-04-04 15:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Victoria','2009-04-04 16:00:00','2009-10-03 15:59:59',36000000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/LHI','2009-01-01 00:00:00','2009-04-04 14:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/LHI','2009-04-04 15:00:00','2009-10-03 15:29:59',37800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Lord_Howe','2009-01-01 00:00:00','2009-04-04 14:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Australia/Lord_Howe','2009-04-04 15:00:00','2009-10-03 15:29:59',37800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Magadan','2009-01-01 00:00:00','2009-03-28 14:59:59',39600000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Magadan','2009-03-28 15:00:00','2009-10-24 14:59:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/McMurdo','2009-01-01 00:00:00','2009-04-04 13:59:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/McMurdo','2009-04-04 14:00:00','2009-09-26 13:59:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/South_Pole','2009-01-01 00:00:00','2009-04-04 13:59:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Antarctica/South_Pole','2009-04-04 14:00:00','2009-09-26 13:59:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Anadyr','2009-01-01 00:00:00','2009-03-28 13:59:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Anadyr','2009-03-28 14:00:00','2009-10-24 13:59:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Kamchatka','2009-01-01 00:00:00','2009-03-28 13:59:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Asia/Kamchatka','2009-03-28 14:00:00','2009-10-24 13:59:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('NST','2009-01-01 00:00:00','2009-04-04 13:59:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('NST','2009-04-04 14:00:00','2009-09-26 13:59:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('NZ','2009-01-01 00:00:00','2009-04-04 13:59:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('NZ','2009-04-04 14:00:00','2009-09-26 13:59:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Auckland','2009-01-01 00:00:00','2009-04-04 13:59:59',46800000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Auckland','2009-04-04 14:00:00','2009-09-26 13:59:59',43200000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('NZ-CHAT','2009-01-01 00:00:00','2009-04-04 13:59:59',49500000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('NZ-CHAT','2009-04-04 14:00:00','2009-09-26 13:59:59',45900000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Chatham','2009-01-01 00:00:00','2009-04-04 13:59:59',49500000)
 
INSERT timezone_offsets(time_zone_id,start_time_gmt,end_time_gmt,offset) 
VALUES('Pacific/Chatham','2009-04-04 14:00:00','2009-09-26 13:59:59',45900000)
 
GO

-- create index
create clustered index tz1 on timezone_offsets(time_zone_id, start_time_gmt, end_time_gmt)

GO

-- convert date to users timezone
if (exists (select 1 from dbo.sysobjects where xtype = 'fn' and name = 'get_local_datetime'))
drop function dbo.get_local_datetime
GO


-- This function returns the datetime in users local timezone, if invalid time zone id is passed to the function it returns
-- GMT time, you can change it to return null or blank as desired.
create function dbo.get_local_datetime
	(@date datetime, @time_zone varchar(25))
returns datetime as
BEGIN
	declare @local_time datetime
	declare @offset_time int
	select @offset_time = offset from timezone_offsets where @date between start_time_gmt and end_time_gmt and time_zone_id = @time_zone
	set @local_time = dateadd(ms, isnull(@offset_time,0), @date)
	return @local_time
END

GO
-- Test script
select distinct time_zone_id, dbo.get_local_datetime(getDate(), time_zone_id) as time_now from timezone_offsets

Rate

Share

Share

Rate