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

Contribution Center

by DaveConvery

SQLServerCentral

In order to contribute to SQLServerCentral, you need to have an account, and be logged in.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-03-25

54,015 reads

Search

by DaveConvery

SQLServerCentral

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-03-25

25,466 reads

Contributors

by DaveConvery

SQLServerCentral

Authors A full list of authors on SQLServerCentral is available here. Leaderboard See how your scores for the forums, Question of the Day, and overall score compare on the leaderboard. Blogs The following content is syndicated from SQL Server-related blogs elsewhere on the web.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-03-25

3,495 reads

Contribute

by DaveConvery

SQLServerCentral

Write for SQLServerCentral - we're looking for new writers for SQL Server articles, scripts and questions.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-03-25

8,031 reads

Privacy Policy

by DaveConvery

SQLServerCentral

Redgate (which means Red Gate Software Limited and its subsidiary Red Gate Software Inc.) respects your privacy. All information you give us is held with the utmost care and security. Please take time to review this privacy policy as it sets out our privacy practices and tells you how your personal information will be treated […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-03-25

6,137 reads

Convert GMT/UTC to Local datetime

Rate

Share

Tags

Share

Rate

Convert GMT/UTC to Local datetime

Rate

Share

Tags

Share

Rate

Related content

Contribution Center

Search

Contributors

Contribute

Privacy Policy