 |
 |
 |
 |
How to update Commerce Server 2007 and Commerce Server 2002 for daylight saving time in 2007
This article describes the changes to daylight saving time
(DST) for 2007 and how to update Microsoft Commerce Server 2007 and Microsoft
Commerce Server 2002 to meet the new DST requirements.
MORE INFORMATION Starting in 2007, the start date and the end date for DST in
the United States will be adjusted to comply with the Energy Policy Act of
2005. DST in the United States will start three weeks earlier than it has
started in the past. DST in the United States will start at 2:00 A.M. on the
second Sunday in March. Additionally, DST will end one week later than it has
ended in the past. DST will end at 2:00 A.M. on the first Sunday in
November. To update an existing data warehouse installation database in Microsoft SQL Server 2005,
follow these steps:
| 1. | Start SQL Server Management Studio. | | 2. | Connect to the instance of SQL Server where your Commerce
Server data warehouse database is located. | | 3. | On the File menu, click
New, and then click Query with Current
Connection. | | 4. | Select the correct Commerce Server data warehouse database
from the database list. | | 5. | Copy the script
that is listed in the "Script" section into the new query window.
| | 6. | Click Execute. |
To update an existing data warehouse installation database in Microsoft SQL Server 2000,
follow these steps:
| 1. | Start SQL Server Query Analyzer. | | 2. | Connect to the instance of SQL Server on which your
Commerce Server data warehouse database is located. | | 3. | Select the correct Commerce Server data warehouse database
from the database list. | | 4. | Copy the script
that is listed in the "Script" section into the new query window.
| | 5. | On the Query menu, click
Execute. |
Script /* Drop existing table -- TblReferenceTimeZone */
IF Exists (SELECT * FROM sysobjects WHERE id = object_id(N'TblReferenceTimeZone')
AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [TblReferenceTimeZone]
GO
/****** Object: Table [dbo].[TblReferenceTimeZone] Script Date: 4/5/99 10:28:10 AM ******/
CREATE TABLE [TblReferenceTimeZone] (
[TzID] [smallint] NULL ,
[DisplayName] [nvarchar] (150) NULL ,
[StdName] [nvarchar] (150) NULL ,
[DltName] [nvarchar] (150) NULL ,
[Bias] [smallint] NULL ,
[StdBias] [smallint] NULL ,
[DltBias] [smallint] NULL ,
[StdYear] [smallint] NULL ,
[StdMonth] [smallint] NULL ,
[StdDayWeek] [smallint] NULL ,
[StdDay] [smallint] NULL ,
[StdHour] [smallint] NULL ,
[StdMin] [smallint] NULL ,
[StdSec] [smallint] NULL ,
[StdMs] [smallint] NULL ,
[DltYear] [smallint] NULL ,
[DltMonth] [smallint] NULL ,
[DltDayWeek] [smallint] NULL ,
[DltDay] [smallint] NULL ,
[DltHour] [smallint] NULL ,
[DltMin] [smallint] NULL ,
[DltSec] [smallint] NULL ,
[DltMs] [smallint] NULL
) ON [PRIMARY]
GO
declare @localized_string_Eniwetok_Kwajalein NVARCHAR(128)
set @localized_string_Eniwetok_Kwajalein = N'(GMT-12:00) Eniwetok, Kwajalein'
declare @localized_string_Dateline_Standard_Time NVARCHAR(128)
set @localized_string_Dateline_Standard_Time = N'Dateline_Standard_Time'
declare @localized_string_Dateline_Daylight_Time NVARCHAR(128)
set @localized_string_Dateline_Daylight_Time = N'Dateline Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (1,@localized_string_Eniwetok_Kwajalein,@localized_string_Dateline_Standard_Time,@localized_string_Dateline_Daylight_Time,720,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Midway_Island_Samoa NVARCHAR(128)
set @localized_string_Midway_Island_Samoa = N'(GMT-11:00) Midway Island, Samoa'
declare @localized_string_Samoa_Standard_Time NVARCHAR(128)
set @localized_string_Samoa_Standard_Time = N'Samoa Standard Time'
declare @localized_string_Samoa_Daylight_Time NVARCHAR(128)
set @localized_string_Samoa_Daylight_Time = N'Samoa Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (2,@localized_string_Midway_Island_Samoa,@localized_string_Samoa_Standard_Time,@localized_string_Samoa_Daylight_Time,660,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Hawaii NVARCHAR(128)
set @localized_string_Hawaii = N'(GMT-10:00) Hawaii'
declare @localized_string_Hawaiian_Standard_Time NVARCHAR(128)
set @localized_string_Hawaiian_Standard_Time = N'Hawaiian Standard Time'
declare @localized_string_Hawaiian_Daylight_Time NVARCHAR(128)
set @localized_string_Hawaiian_Daylight_Time = N'Hawaiian Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (3,@localized_string_Hawaii,@localized_string_Hawaiian_Standard_Time,@localized_string_Hawaiian_Daylight_Time,600,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Alaska NVARCHAR(128)
set @localized_string_Alaska = N'(GMT-09:00) Alaska'
declare @localized_string_Alaskan_Standard_Time NVARCHAR(128)
set @localized_string_Alaskan_Standard_Time = N'Alaskan Standard Time'
declare @localized_string_Alaskan_Daylight_Time NVARCHAR(128)
set @localized_string_Alaskan_Daylight_Time = N'Alaskan Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (4,@localized_string_Alaska,@localized_string_Alaskan_Standard_Time,@localized_string_Alaskan_Daylight_Time,540,0,-60,0,11,0,1,2,0,0,0,0,3,0,2,2,0,0,0)
declare @localized_string_Pacific_Time NVARCHAR(128)
set @localized_string_Pacific_Time = N'(GMT-08:00) Pacific Time (US & Canada); Tijuana'
declare @localized_string_Pacific_Standard_Time NVARCHAR(128)
set @localized_string_Pacific_Standard_Time = N'Pacific Standard Time'
declare @localized_string_Pacific_Daylight_Time NVARCHAR(128)
set @localized_string_Pacific_Daylight_Time = N'Pacific Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (5,@localized_string_Pacific_Time,@localized_string_Pacific_Standard_Time,@localized_string_Pacific_Daylight_Time,480,0,-60,0,11,0,1,2,0,0,0,0,3,0,2,2,0,0,0)
declare @localized_string_Arizona NVARCHAR(128)
set @localized_string_Arizona = N'(GMT-07:00) Arizona'
declare @localized_string_US_Mountain_Standard_Time NVARCHAR(128)
set @localized_string_US_Mountain_Standard_Time = N'US Mountain Standard Time'
declare @localized_string_US_Mountain_Daylight_Time NVARCHAR(128)
set @localized_string_US_Mountain_Daylight_Time = N'US Mountain Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (6,@localized_string_Arizona,@localized_string_US_Mountain_Standard_Time,@localized_string_US_Mountain_Daylight_Time,420,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Mountain_Time NVARCHAR(128)
set @localized_string_Mountain_Time = N'(GMT-07:00) Mountain Time (US & Canada)'
declare @localized_string_Mountain_Standard_Time NVARCHAR(128)
set @localized_string_Mountain_Standard_Time = N'Mountain Standard Time'
declare @localized_string_Mountain_Daylight_Time NVARCHAR(128)
set @localized_string_Mountain_Daylight_Time = N'Mountain Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (7,@localized_string_Mountain_Time,@localized_string_Mountain_Standard_Time,@localized_string_Mountain_Daylight_Time,420,0,-60,0,11,0,1,2,0,0,0,0,3,0,2,2,0,0,0)
declare @localized_string_Mexico_City NVARCHAR(128)
set @localized_string_Mexico_City = N'(GMT-06:00) Mexico City'
declare @localized_string_Mexico_Standard_Time NVARCHAR(128)
set @localized_string_Mexico_Standard_Time = N'Mexico Standard Time'
declare @localized_string_Mexico_Daylight_Time NVARCHAR(128)
set @localized_string_Mexico_Daylight_Time = N'Mexico Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (8,@localized_string_Mexico_City,@localized_string_Mexico_Standard_Time,@localized_string_Mexico_Daylight_Time,360,0,-60,0,10,0,5,2,0,0,0,0,4,0,1,2,0,0,0)
declare @localized_string_Central_Time NVARCHAR(128)
set @localized_string_Central_Time = N'(GMT-06:00) Central Time (US & Canada)'
declare @localized_string_Central_Standard_Time NVARCHAR(128)
set @localized_string_Central_Standard_Time = N'Central Standard Time'
declare @localized_string_Central_Daylight_Time NVARCHAR(128)
set @localized_string_Central_Daylight_Time = N'Central Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (9,@localized_string_Central_Time,@localized_string_Central_Standard_Time,@localized_string_Central_Daylight_Time,360,0,-60,0,11,0,1,2,0,0,0,0,3,0,2,2,0,0,0)
declare @localized_string_Central_America NVARCHAR(128)
set @localized_string_Central_America = N'(GMT-06:00) Central America'
declare @localized_string_Central_America_Standard_Time NVARCHAR(128)
set @localized_string_Central_America_Standard_Time = N'Central America Standard Time'
declare @localized_string_Central_America_Daylight_Time NVARCHAR(128)
set @localized_string_Central_America_Daylight_Time = N'Central America Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (10,@localized_string_Central_America,@localized_string_Central_America_Standard_Time,@localized_string_Central_America_Daylight_Time,360,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Saskatchewan NVARCHAR(128)
set @localized_string_Saskatchewan = N'(GMT-06:00) Saskatchewan'
declare @localized_string_Canada_Central_Standard_Time NVARCHAR(128)
set @localized_string_Canada_Central_Standard_Time = N'Canada Central Standard Time'
declare @localized_string_Canada_Central_Daylight_Time NVARCHAR(128)
set @localized_string_Canada_Central_Daylight_Time = N'Canada Central Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (11,@localized_string_Saskatchewan,@localized_string_Canada_Central_Standard_Time,@localized_string_Canada_Central_Daylight_Time,360,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Indiana NVARCHAR(128)
set @localized_string_Indiana = N'(GMT-05:00) Indiana (East)'
declare @localized_string_US_Eastern_Standard_Time NVARCHAR(128)
set @localized_string_US_Eastern_Standard_Time = N'US Eastern Standard Time'
declare @localized_string_US_Eastern_Daylight_Time NVARCHAR(128)
set @localized_string_US_Eastern_Daylight_Time = N'US Eastern Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (12,@localized_string_Indiana,@localized_string_US_Eastern_Standard_Time,@localized_string_US_Eastern_Daylight_Time,300,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Bogota_Lima_Quito NVARCHAR(128)
set @localized_string_Bogota_Lima_Quito = N'(GMT-05:00) Bogota, Lima, Quito'
declare @localized_string_SA_Pacific_Standard_Time NVARCHAR(128)
set @localized_string_SA_Pacific_Standard_Time = N'SA Pacific Standard Time'
declare @localized_string_SA_Pacific_Daylight_Time NVARCHAR(128)
set @localized_string_SA_Pacific_Daylight_Time = N'SA Pacific Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (13,@localized_string_Bogota_Lima_Quito,@localized_string_SA_Pacific_Standard_Time,@localized_string_SA_Pacific_Daylight_Time,300,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Eastern_Time NVARCHAR(128)
set @localized_string_Eastern_Time = N'(GMT-05:00) Eastern Time (US & Canada)'
declare @localized_string_Eastern_Standard_Time NVARCHAR(128)
set @localized_string_Eastern_Standard_Time = N'Eastern Standard Time'
declare @localized_string_Eastern_Daylight_Time NVARCHAR(128)
set @localized_string_Eastern_Daylight_Time = N'Eastern Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (14,@localized_string_Eastern_Time,@localized_string_Eastern_Standard_Time,@localized_string_Eastern_Daylight_Time,300,0,-60,0,11,0,1,2,0,0,0,0,3,0,2,2,0,0,0)
declare @localized_string_Caracas_La_Paz NVARCHAR(128)
set @localized_string_Caracas_La_Paz = N'(GMT-04:00) Caracas, La Paz'
declare @localized_string_SA_Western_Standard_Time NVARCHAR(128)
set @localized_string_SA_Western_Standard_Time = N'SA Western Standard Time'
declare @localized_string_SA_Western_Daylight_Time NVARCHAR(128)
set @localized_string_SA_Western_Daylight_Time = N'SA Western Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (15,@localized_string_Caracas_La_Paz,@localized_string_SA_Western_Standard_Time,@localized_string_SA_Western_Daylight_Time,240,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Santiago NVARCHAR(128)
set @localized_string_Santiago = N'(GMT-04:00) Santiago'
declare @localized_string_Pacific_SA_Standard_Time NVARCHAR(128)
set @localized_string_Pacific_SA_Standard_Time = N'Pacific SA Standard Time'
declare @localized_string_Pacific_SA_Daylight_Time NVARCHAR(128)
set @localized_string_Pacific_SA_Daylight_Time = N'Pacific SA Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (16,@localized_string_Santiago,@localized_string_Pacific_SA_Standard_Time,@localized_string_Pacific_SA_Daylight_Time,240,0,-60,0,3,6,2,0,0,0,0,0,10,6,2,0,0,0,0)
declare @localized_string_Atlantic_Time NVARCHAR(128)
set @localized_string_Atlantic_Time = N'(GMT-04:00) Atlantic Time (Canada)'
declare @localized_string_Atlantic_Standard_Time NVARCHAR(128)
set @localized_string_Atlantic_Standard_Time = N'Atlantic Standard Time'
declare @localized_string_Atlantic_Daylight_Time NVARCHAR(128)
set @localized_string_Atlantic_Daylight_Time = N'Atlantic Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (17,@localized_string_Atlantic_Time,@localized_string_Atlantic_Standard_Time,@localized_string_Atlantic_Daylight_Time,240,0,-60,0,10,0,5,2,0,0,0,0,4,0,1,2,0,0,0)
declare @localized_string_Newfoundland NVARCHAR(128)
set @localized_string_Newfoundland = N'(GMT-03:30) Newfoundland'
declare @localized_string_Newfoundland_Standard_Time NVARCHAR(128)
set @localized_string_Newfoundland_Standard_Time = N'Newfoundland Standard Time'
declare @localized_string_Newfoundland_Daylight_Time NVARCHAR(128)
set @localized_string_Newfoundland_Daylight_Time = N'Newfoundland Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (18,@localized_string_Newfoundland,@localized_string_Newfoundland_Standard_Time,@localized_string_Newfoundland_Daylight_Time,210,0,-60,0,10,0,5,2,0,0,0,0,4,0,1,2,0,0,0)
declare @localized_string_Buenos_Aires_Georgetown NVARCHAR(128)
set @localized_string_Buenos_Aires_Georgetown = N'(GMT-03:00) Buenos Aires, Georgetown'
declare @localized_string_SA_Eastern_Standard_Time NVARCHAR(128)
set @localized_string_SA_Eastern_Standard_Time = N'SA Eastern Standard Time'
declare @localized_string_SA_Eastern_Daylight_Time NVARCHAR(128)
set @localized_string_SA_Eastern_Daylight_Time = N'SA Eastern Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (19,@localized_string_Buenos_Aires_Georgetown,@localized_string_SA_Eastern_Standard_Time,@localized_string_SA_Eastern_Daylight_Time,180,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Greenland NVARCHAR(128)
set @localized_string_Greenland = N'(GMT-03:00) Greenland'
declare @localized_string_Greenland_Standard_Time NVARCHAR(128)
set @localized_string_Greenland_Standard_Time = N'Greenland Standard Time'
declare @localized_string_Greenland_Daylight_Time NVARCHAR(128)
set @localized_string_Greenland_Daylight_Time = N'Greenland Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (20,@localized_string_Greenland,@localized_string_Greenland_Standard_Time,@localized_string_Greenland_Daylight_Time,180,0,-60,0,10,0,5,2,0,0,0,0,4,0,1,2,0,0,0)
declare @localized_string_Brasilia NVARCHAR(128)
set @localized_string_Brasilia = N'(GMT-03:00) Brasilia'
declare @localized_string_E_South_America_Standard_Time NVARCHAR(128)
set @localized_string_E_South_America_Standard_Time = N'E. South America Standard Time'
declare @localized_string_E_South_America_Daylight_Time NVARCHAR(128)
set @localized_string_E_South_America_Daylight_Time = N'E. South America Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (21,@localized_string_Brasilia,@localized_string_E_South_America_Standard_Time,@localized_string_E_South_America_Daylight_Time,180,0,-60,0,2,0,2,2,0,0,0,0,10,0,3,2,0,0,0)
declare @localized_string_Mid_Atlantic NVARCHAR(128)
set @localized_string_Mid_Atlantic = N'(GMT-02:00) Mid-Atlantic'
declare @localized_string_Mid_Atlantic_Standard_Time NVARCHAR(128)
set @localized_string_Mid_Atlantic_Standard_Time = N'Mid-Atlantic Standard Time'
declare @localized_string_Mid_Atlantic_Daylight_Time NVARCHAR(128)
set @localized_string_Mid_Atlantic_Daylight_Time = N'Mid-Atlantic Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (22,@localized_string_Mid_Atlantic,@localized_string_Mid_Atlantic_Standard_Time,@localized_string_Mid_Atlantic_Daylight_Time,120,0,-60,0,9,0,5,2,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Cape_Verde NVARCHAR(128)
set @localized_string_Cape_Verde = N'(GMT-01:00) Cape Verde Is.'
declare @localized_string_Cape_Verde_Standard_Time NVARCHAR(128)
set @localized_string_Cape_Verde_Standard_Time = N'Cape Verde Standard Time'
declare @localized_string_Cape_Verde_Daylight_Time NVARCHAR(128)
set @localized_string_Cape_Verde_Daylight_Time = N'Cape Verde Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (23,@localized_string_Cape_Verde,@localized_string_Cape_Verde_Standard_Time,@localized_string_Cape_Verde_Daylight_Time,60,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Azores NVARCHAR(128)
set @localized_string_Azores = N'(GMT-01:00) Azores'
declare @localized_string_Azores_Standard_Time NVARCHAR(128)
set @localized_string_Azores_Standard_Time = N'Azores Standard Time'
declare @localized_string_Azores_Daylight_Time NVARCHAR(128)
set @localized_string_Azores_Daylight_Time = N'Azores Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (24,@localized_string_Azores,@localized_string_Azores_Standard_Time,@localized_string_Azores_Daylight_Time,60,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Casablanca_Monrovia NVARCHAR(128)
set @localized_string_Casablanca_Monrovia = N'(GMT) Casablanca, Monrovia'
declare @localized_string_Greenwich_Standard_Time NVARCHAR(128)
set @localized_string_Greenwich_Standard_Time = N'Greenwich Standard Time'
declare @localized_string_Greenwich_Daylight_Time NVARCHAR(128)
set @localized_string_Greenwich_Daylight_Time = N'Greenwich Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (25,@localized_string_Casablanca_Monrovia,@localized_string_Greenwich_Standard_Time,@localized_string_Greenwich_Daylight_Time,0,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Greenwich_Mean_Time_Dublin_Edinburgh_Lisbon_London NVARCHAR(128)
set @localized_string_Greenwich_Mean_Time_Dublin_Edinburgh_Lisbon_London = N'(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London'
declare @localized_string_GMT_Standard_Time NVARCHAR(128)
set @localized_string_GMT_Standard_Time = N'GMT Standard Time'
declare @localized_string_GMT_Daylight_Time NVARCHAR(128)
set @localized_string_GMT_Daylight_Time = N'GMT Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (26,@localized_string_Greenwich_Mean_Time_Dublin_Edinburgh_Lisbon_London,@localized_string_GMT_Standard_Time,@localized_string_GMT_Daylight_Time,0,0,-60,0,10,0,5,2,0,0,0,0,3,0,5,1,0,0,0)
declare @localized_string_Amsterdam_Berlin_Bern_Rome_Stockholm_Vienna NVARCHAR(128)
set @localized_string_Amsterdam_Berlin_Bern_Rome_Stockholm_Vienna = N'(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna'
declare @localized_string_W_Europe_Standard_Time NVARCHAR(128)
set @localized_string_W_Europe_Standard_Time = N'W. Europe Standard Time'
declare @localized_string_W_Europe_Daylight_Time NVARCHAR(128)
set @localized_string_W_Europe_Daylight_Time = N'W. Europe Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (27,@localized_string_Amsterdam_Berlin_Bern_Rome_Stockholm_Vienna,@localized_string_W_Europe_Standard_Time,@localized_string_W_Europe_Daylight_Time,-60,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_West_Central_Africa NVARCHAR(128)
set @localized_string_West_Central_Africa = N'(GMT+01:00) West Central Africa'
declare @localized_string_W_Central_Africa_Standard_Time NVARCHAR(128)
set @localized_string_W_Central_Africa_Standard_Time = N'W. Central Africa Standard Time'
declare @localized_string_W_Central_Africa_Daylight_Time NVARCHAR(128)
set @localized_string_W_Central_Africa_Daylight_Time = N'W. Central Africa Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (28,@localized_string_West_Central_Africa,@localized_string_W_Central_Africa_Standard_Time,@localized_string_W_Central_Africa_Daylight_Time,-60,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Brussels_Copenhagen_Madrid_Paris NVARCHAR(128)
set @localized_string_Brussels_Copenhagen_Madrid_Paris = N'(GMT+01:00) Brussels, Copenhagen, Madrid, Paris'
declare @localized_string_Romance_Standard_Time NVARCHAR(128)
set @localized_string_Romance_Standard_Time = N'Romance Standard Time'
declare @localized_string_Romance_Daylight_Time NVARCHAR(128)
set @localized_string_Romance_Daylight_Time = N'Romance Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (29,@localized_string_Brussels_Copenhagen_Madrid_Paris,@localized_string_Romance_Standard_Time,@localized_string_Romance_Daylight_Time,-60,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Sarajevo_Skopje_Sofija_Vilnius_Warsaw_Zagreb NVARCHAR(128)
set @localized_string_Sarajevo_Skopje_Sofija_Vilnius_Warsaw_Zagreb = N'(GMT+01:00) Sarajevo, Skopje, Sofija, Vilnius, Warsaw, Zagreb'
declare @localized_string_Central_European_Standard_Time NVARCHAR(128)
set @localized_string_Central_European_Standard_Time = N'Central European Standard Time'
declare @localized_string_Central_European_Daylight_Time NVARCHAR(128)
set @localized_string_Central_European_Daylight_Time = N'Central European Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (30,@localized_string_Sarajevo_Skopje_Sofija_Vilnius_Warsaw_Zagreb,@localized_string_Central_European_Standard_Time,@localized_string_Central_European_Daylight_Time,-60,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Belgrade_Bratislava_Budapest_Ljubljana_Prague NVARCHAR(128)
set @localized_string_Belgrade_Bratislava_Budapest_Ljubljana_Prague = N'(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague'
declare @localized_string_Central_Europe_Standard_Time NVARCHAR(128)
set @localized_string_Central_Europe_Standard_Time = N'Central Europe Standard Time'
declare @localized_string_Central_Europe_Daylight_Time NVARCHAR(128)
set @localized_string_Central_Europe_Daylight_Time = N'Central Europe Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (31,@localized_string_Belgrade_Bratislava_Budapest_Ljubljana_Prague,@localized_string_Central_Europe_Standard_Time,@localized_string_Central_Europe_Daylight_Time,-60,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Harare_Pretoria NVARCHAR(128)
set @localized_string_Harare_Pretoria = N'(GMT+02:00) Harare, Pretoria'
declare @localized_string_South_Africa_Standard_Time NVARCHAR(128)
set @localized_string_South_Africa_Standard_Time = N'South Africa Standard Time'
declare @localized_string_South_Africa_Daylight_Time NVARCHAR(128)
set @localized_string_South_Africa_Daylight_Time = N'South Africa Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (32,@localized_string_Harare_Pretoria,@localized_string_South_Africa_Standard_Time,@localized_string_South_Africa_Daylight_Time,-120,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Jerusalem NVARCHAR(128)
set @localized_string_Jerusalem = N'(GMT+02:00) Jerusalem'
declare @localized_string_Israel_Standard_Time NVARCHAR(128)
set @localized_string_Israel_Standard_Time = N'Israel Standard Time'
declare @localized_string_Jerusalem_Daylight_Time NVARCHAR(128)
set @localized_string_Jerusalem_Daylight_Time = N'Jerusalem Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (33,@localized_string_Jerusalem,@localized_string_Israel_Standard_Time,@localized_string_Jerusalem_Daylight_Time,-120,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Athens_Istanbul_Minsk NVARCHAR(128)
set @localized_string_Athens_Istanbul_Minsk = N'(GMT+02:00) Athens, Istanbul, Minsk'
declare @localized_string_GTB_Standard_Time NVARCHAR(128)
set @localized_string_GTB_Standard_Time = N'GTB Standard Time'
declare @localized_string_GTB_Daylight_Time NVARCHAR(128)
set @localized_string_GTB_Daylight_Time = N'GTB Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (34,@localized_string_Athens_Istanbul_Minsk,@localized_string_GTB_Standard_Time,@localized_string_GTB_Daylight_Time,-120,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Helsinki_Riga_Tallinn NVARCHAR(128)
set @localized_string_Helsinki_Riga_Tallinn = N'(GMT+02:00) Helsinki, Riga, Tallinn'
declare @localized_string_FLE_Standard_Time NVARCHAR(128)
set @localized_string_FLE_Standard_Time = N'FLE Standard Time'
declare @localized_string_FLE_Daylight_Time NVARCHAR(128)
set @localized_string_FLE_Daylight_Time = N'FLE Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (35,@localized_string_Helsinki_Riga_Tallinn,@localized_string_FLE_Standard_Time,@localized_string_FLE_Daylight_Time,-120,0,-60,0,10,0,5,4,0,0,0,0,3,0,5,3,0,0,0)
declare @localized_string_Cairo NVARCHAR(128)
set @localized_string_Cairo = N'(GMT+02:00) Cairo'
declare @localized_string_Egypt_Standard_Time NVARCHAR(128)
set @localized_string_Egypt_Standard_Time = N'Egypt Standard Time'
declare @localized_string_Egypt_Daylight_Time NVARCHAR(128)
set @localized_string_Egypt_Daylight_Time = N'Egypt Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (36,@localized_string_Cairo,@localized_string_Egypt_Standard_Time,@localized_string_Egypt_Daylight_Time,-120,0,-60,0,9,3,5,2,0,0,0,0,5,5,1,2,0,0,0)
declare @localized_string_Bucharest NVARCHAR(128)
set @localized_string_Bucharest = N'(GMT+02:00) Bucharest'
declare @localized_string_E_Europe_Standard_Time NVARCHAR(128)
set @localized_string_E_Europe_Standard_Time = N'E. Europe Standard Time'
declare @localized_string_E_Europe_Daylight_Time NVARCHAR(128)
set @localized_string_E_Europe_Daylight_Time = N'E. Europe Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (37,@localized_string_Bucharest,@localized_string_E_Europe_Standard_Time,@localized_string_E_Europe_Daylight_Time,-120,0,-60,0,9,0,5,1,0,0,0,0,3,0,5,0,0,0,0)
declare @localized_string_Moscow_St_Petersburg_Volgograd NVARCHAR(128)
set @localized_string_Moscow_St_Petersburg_Volgograd = N'(GMT+03:00) Moscow, St. Petersburg, Volgograd'
declare @localized_string_Russian_Standard_Time NVARCHAR(128)
set @localized_string_Russian_Standard_Time = N'Russian Standard Time'
declare @localized_string_Russian_Daylight_Time NVARCHAR(128)
set @localized_string_Russian_Daylight_Time = N'Russian Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (38,@localized_string_Moscow_St_Petersburg_Volgograd,@localized_string_Russian_Standard_Time,@localized_string_Russian_Daylight_Time,-180,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Nairobi NVARCHAR(128)
set @localized_string_Nairobi = N'(GMT+03:00) Nairobi'
declare @localized_string_E_Africa_Standard_Time NVARCHAR(128)
set @localized_string_E_Africa_Standard_Time = N'E. Africa Standard Time'
declare @localized_string_E_Africa_Daylight_Time NVARCHAR(128)
set @localized_string_E_Africa_Daylight_Time = N'E. Africa Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (39,@localized_string_Nairobi,@localized_string_E_Africa_Standard_Time,@localized_string_E_Africa_Daylight_Time,-180,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Baghdad NVARCHAR(128)
set @localized_string_Baghdad = N'(GMT+03:00) Baghdad'
declare @localized_string_Arabic_Standard_Time NVARCHAR(128)
set @localized_string_Arabic_Standard_Time = N'Arabic Standard Time'
declare @localized_string_Arabic_Daylight_Time NVARCHAR(128)
set @localized_string_Arabic_Daylight_Time = N'Arabic Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (40,@localized_string_Baghdad,@localized_string_Arabic_Standard_Time,@localized_string_Arabic_Daylight_Time,-180,0,-60,0,10,0,1,4,0,0,0,0,4,0,1,3,0,0,0)
declare @localized_string_Kuwait_Riyadh NVARCHAR(128)
set @localized_string_Kuwait_Riyadh = N'(GMT+03:00) Kuwait, Riyadh'
declare @localized_string_Arab_Standard_Time NVARCHAR(128)
set @localized_string_Arab_Standard_Time = N'Arab Standard Time'
declare @localized_string_Arab_Daylight_Time NVARCHAR(128)
set @localized_string_Arab_Daylight_Time = N'Arab Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (41,@localized_string_Kuwait_Riyadh,@localized_string_Arab_Standard_Time,@localized_string_Arab_Daylight_Time,-180,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Tehran NVARCHAR(128)
set @localized_string_Tehran = N'(GMT+03:30) Tehran'
declare @localized_string_Iran_Standard_Time NVARCHAR(128)
set @localized_string_Iran_Standard_Time = N'Iran Standard Time'
declare @localized_string_Iran_Daylight_Time NVARCHAR(128)
set @localized_string_Iran_Daylight_Time = N'Iran Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (42,@localized_string_Tehran,@localized_string_Iran_Standard_Time,@localized_string_Iran_Daylight_Time,-210,0,-60,0,9,2,4,2,0,0,0,0,3,0,1,2,0,0,0)
declare @localized_string_Baku_Tbilisi_Yerevan NVARCHAR(128)
set @localized_string_Baku_Tbilisi_Yerevan = N'(GMT+04:00) Baku, Tbilisi, Yerevan'
declare @localized_string_Caucasus_Standard_Time NVARCHAR(128)
set @localized_string_Caucasus_Standard_Time = N'Caucasus Standard Time'
declare @localized_string_Caucasus_Daylight_Time NVARCHAR(128)
set @localized_string_Caucasus_Daylight_Time = N'Caucasus Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (43,@localized_string_Baku_Tbilisi_Yerevan,@localized_string_Caucasus_Standard_Time,@localized_string_Caucasus_Daylight_Time,-240,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Abu_Dhabi_Muscat NVARCHAR(128)
set @localized_string_Abu_Dhabi_Muscat = N'(GMT+04:00) Abu Dhabi, Muscat'
declare @localized_string_Arabian_Standard_Time NVARCHAR(128)
set @localized_string_Arabian_Standard_Time = N'Arabian Standard Time'
declare @localized_string_Arabian_Daylight_Time NVARCHAR(128)
set @localized_string_Arabian_Daylight_Time = N'Arabian Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (44,@localized_string_Abu_Dhabi_Muscat,@localized_string_Arabian_Standard_Time,@localized_string_Arabian_Daylight_Time,-240,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Kabul NVARCHAR(128)
set @localized_string_Kabul = N'(GMT+04:30) Kabul'
declare @localized_string_Afghanistan_Standard_Time NVARCHAR(128)
set @localized_string_Afghanistan_Standard_Time = N'Afghanistan Standard Time'
declare @localized_string_Afghanistan_Daylight_Time NVARCHAR(128)
set @localized_string_Afghanistan_Daylight_Time = N'Afghanistan Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (45,@localized_string_Kabul,@localized_string_Afghanistan_Standard_Time,@localized_string_Afghanistan_Daylight_Time,-270,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Islamabad_Karachi_Tashkent NVARCHAR(128)
set @localized_string_Islamabad_Karachi_Tashkent = N'(GMT+05:00) Islamabad, Karachi, Tashkent'
declare @localized_string_West_Asia_Standard_Time NVARCHAR(128)
set @localized_string_West_Asia_Standard_Time = N'West Asia Standard Time'
declare @localized_string_West_Asia_Daylight_Time NVARCHAR(128)
set @localized_string_West_Asia_Daylight_Time = N'West Asia Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (46,@localized_string_Islamabad_Karachi_Tashkent,@localized_string_West_Asia_Standard_Time,@localized_string_West_Asia_Daylight_Time,-300,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Ekaterinburg NVARCHAR(128)
set @localized_string_Ekaterinburg = N'(GMT+05:00) Ekaterinburg'
declare @localized_string_Ekaterinburg_Standard_Time NVARCHAR(128)
set @localized_string_Ekaterinburg_Standard_Time = N'Ekaterinburg Standard Time'
declare @localized_string_Ekaterinburg_Daylight_Time NVARCHAR(128)
set @localized_string_Ekaterinburg_Daylight_Time = N'Ekaterinburg Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (47,@localized_string_Ekaterinburg,@localized_string_Ekaterinburg_Standard_Time,@localized_string_Ekaterinburg_Daylight_Time,-300,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Calcutta_Chennai_Mumbai_New_Delhi NVARCHAR(128)
set @localized_string_Calcutta_Chennai_Mumbai_New_Delhi = N'(GMT+05:30) Calcutta, Chennai, Mumbai, New Delhi'
declare @localized_string_India_Standard_Time NVARCHAR(128)
set @localized_string_India_Standard_Time = N'India Standard Time'
declare @localized_string_India_Daylight_Time NVARCHAR(128)
set @localized_string_India_Daylight_Time = N'India Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (48,@localized_string_Calcutta_Chennai_Mumbai_New_Delhi,@localized_string_India_Standard_Time,@localized_string_India_Daylight_Time,-330,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Kathmandu NVARCHAR(128)
set @localized_string_Kathmandu = N'(GMT+05:45) Kathmandu'
declare @localized_string_Nepal_Standard_Time NVARCHAR(128)
set @localized_string_Nepal_Standard_Time = N'Nepal Standard Time'
declare @localized_string_Nepal_Daylight_Time NVARCHAR(128)
set @localized_string_Nepal_Daylight_Time = N'Nepal Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (49,@localized_string_Kathmandu,@localized_string_Nepal_Standard_Time,@localized_string_Nepal_Daylight_Time,-345,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Sri_Jayawardenepura NVARCHAR(128)
set @localized_string_Sri_Jayawardenepura = N'(GMT+06:00) Sri Jayawardenepura'
declare @localized_string_Sri_Lanka_Standard_Time NVARCHAR(128)
set @localized_string_Sri_Lanka_Standard_Time = N'Sri Lanka Standard Time'
declare @localized_string_Sri_Lanka_Daylight_Time NVARCHAR(128)
set @localized_string_Sri_Lanka_Daylight_Time = N'Sri Lanka Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (50,@localized_string_Sri_Jayawardenepura,@localized_string_Sri_Lanka_Standard_Time,@localized_string_Sri_Lanka_Daylight_Time,-360,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Almaty_Novosibirsk NVARCHAR(128)
set @localized_string_Almaty_Novosibirsk = N'(GMT+06:00) Almaty, Novosibirsk'
declare @localized_string_N_Central_Asia_Standard_Time NVARCHAR(128)
set @localized_string_N_Central_Asia_Standard_Time = N'N. Central Asia Standard Time'
declare @localized_string_N_Central_Asia_Daylight_Time NVARCHAR(128)
set @localized_string_N_Central_Asia_Daylight_Time = N'N. Central Asia Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (51,@localized_string_Almaty_Novosibirsk,@localized_string_N_Central_Asia_Standard_Time,@localized_string_N_Central_Asia_Daylight_Time,-360,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Astana_Dhaka NVARCHAR(128)
set @localized_string_Astana_Dhaka = N'(GMT+06:00) Astana, Dhaka'
declare @localized_string_Central_Asia_Standard_Time NVARCHAR(128)
set @localized_string_Central_Asia_Standard_Time = N'Central Asia Standard Time'
declare @localized_string_Central_Asia_Daylight_Time NVARCHAR(128)
set @localized_string_Central_Asia_Daylight_Time = N'Central Asia Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (52,@localized_string_Astana_Dhaka,@localized_string_Central_Asia_Standard_Time,@localized_string_Central_Asia_Daylight_Time,-360,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Rangoon NVARCHAR(128)
set @localized_string_Rangoon = N'(GMT+06:30) Rangoon'
declare @localized_string_Myanmar_Standard_Time NVARCHAR(128)
set @localized_string_Myanmar_Standard_Time = N'Myanmar Standard Time'
declare @localized_string_Myanmar_Daylight_Time NVARCHAR(128)
set @localized_string_Myanmar_Daylight_Time = N'Myanmar Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (53,@localized_string_Rangoon,@localized_string_Myanmar_Standard_Time,@localized_string_Myanmar_Daylight_Time,-390,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Bangkok_Hanoi_Jakarta NVARCHAR(128)
set @localized_string_Bangkok_Hanoi_Jakarta = N'(GMT+07:00) Bangkok, Hanoi, Jakarta'
declare @localized_string_SE_Asia_Standard_Time NVARCHAR(128)
set @localized_string_SE_Asia_Standard_Time = N'SE Asia Standard Time'
declare @localized_string_SE_Asia_Daylight_Time NVARCHAR(128)
set @localized_string_SE_Asia_Daylight_Time = N'SE Asia Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (54,@localized_string_Bangkok_Hanoi_Jakarta,@localized_string_SE_Asia_Standard_Time,@localized_string_SE_Asia_Daylight_Time,-420,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Krasnoyarsk NVARCHAR(128)
set @localized_string_Krasnoyarsk = N'(GMT+07:00) Krasnoyarsk'
declare @localized_string_North_Asia_Standard_Time NVARCHAR(128)
set @localized_string_North_Asia_Standard_Time = N'North Asia Standard Time'
declare @localized_string_North_Asia_Daylight_Time NVARCHAR(128)
set @localized_string_North_Asia_Daylight_Time = N'North Asia Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (55,@localized_string_Krasnoyarsk,@localized_string_North_Asia_Standard_Time,@localized_string_North_Asia_Daylight_Time,-420,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Perth NVARCHAR(128)
set @localized_string_Perth = N'(GMT+08:00) Perth'
declare @localized_string_W_Australia_Standard_Time NVARCHAR(128)
set @localized_string_W_Australia_Standard_Time = N'W. Australia Standard Time'
declare @localized_string_W_Australia_Daylight_Time NVARCHAR(128)
set @localized_string_W_Australia_Daylight_Time = N'W. Australia Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (56,@localized_string_Perth,@localized_string_W_Australia_Standard_Time,@localized_string_W_Australia_Daylight_Time,-480,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Taipei NVARCHAR(128)
set @localized_string_Taipei = N'(GMT+08:00) Taipei'
declare @localized_string_Taipei_Standard_Time NVARCHAR(128)
set @localized_string_Taipei_Standard_Time = N'Taipei Standard Time'
declare @localized_string_Taipei_Daylight_Time NVARCHAR(128)
set @localized_string_Taipei_Daylight_Time = N'Taipei Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (57,@localized_string_Taipei,@localized_string_Taipei_Standard_Time,@localized_string_Taipei_Daylight_Time,-480,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Kuala_Lumpur_Singapore NVARCHAR(128)
set @localized_string_Kuala_Lumpur_Singapore = N'(GMT+08:00) Kuala Lumpur, Singapore'
declare @localized_string_Singapore_Standard_Time NVARCHAR(128)
set @localized_string_Singapore_Standard_Time = N'Singapore Standard Time'
declare @localized_string_Malay_Peninsula_Daylight_Time NVARCHAR(128)
set @localized_string_Malay_Peninsula_Daylight_Time = N'Malay Peninsula Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (58,@localized_string_Kuala_Lumpur_Singapore,@localized_string_Singapore_Standard_Time,@localized_string_Malay_Peninsula_Daylight_Time,-480,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Irkutsk_Ulaan_Bataar NVARCHAR(128)
set @localized_string_Irkutsk_Ulaan_Bataar = N'(GMT+08:00) Irkutsk, Ulaan Bataar'
declare @localized_string_North_Asia_East_Standard_Time NVARCHAR(128)
set @localized_string_North_Asia_East_Standard_Time = N'North Asia East Standard Time'
declare @localized_string_North_Asia_East_Daylight_Time NVARCHAR(128)
set @localized_string_North_Asia_East_Daylight_Time = N'North Asia East Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (59,@localized_string_Irkutsk_Ulaan_Bataar,@localized_string_North_Asia_East_Standard_Time,@localized_string_North_Asia_East_Daylight_Time,-480,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Beijing_Chongqing_Hong_Kong_Urumqi NVARCHAR(128)
set @localized_string_Beijing_Chongqing_Hong_Kong_Urumqi = N'(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi'
declare @localized_string_China_Standard_Time NVARCHAR(128)
set @localized_string_China_Standard_Time = N'China Standard Time'
declare @localized_string_China_Daylight_Time NVARCHAR(128)
set @localized_string_China_Daylight_Time = N'China Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (60,@localized_string_Beijing_Chongqing_Hong_Kong_Urumqi,@localized_string_China_Standard_Time,@localized_string_China_Daylight_Time,-480,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Yakutsk NVARCHAR(128)
set @localized_string_Yakutsk = N'(GMT+09:00) Yakutsk'
declare @localized_string_Yakutsk_Standard_Time NVARCHAR(128)
set @localized_string_Yakutsk_Standard_Time = N'Yakutsk Standard Time'
declare @localized_string_Yakutsk_Daylight_Time NVARCHAR(128)
set @localized_string_Yakutsk_Daylight_Time = N'Yakutsk Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (61,@localized_string_Yakutsk,@localized_string_Yakutsk_Standard_Time,@localized_string_Yakutsk_Daylight_Time,-540,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Osaka_Sapporo_Tokyo NVARCHAR(128)
set @localized_string_Osaka_Sapporo_Tokyo = N'(GMT+09:00) Osaka, Sapporo, Tokyo'
declare @localized_string_Tokyo_Standard_Time NVARCHAR(128)
set @localized_string_Tokyo_Standard_Time = N'Tokyo Standard Time'
declare @localized_string_Tokyo_Daylight_Time NVARCHAR(128)
set @localized_string_Tokyo_Daylight_Time = N'Tokyo Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (62,@localized_string_Osaka_Sapporo_Tokyo,@localized_string_Tokyo_Standard_Time,@localized_string_Tokyo_Daylight_Time,-540,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Seoul NVARCHAR(128)
set @localized_string_Seoul = N'(GMT+09:00) Seoul'
declare @localized_string_Korea_Standard_Time NVARCHAR(128)
set @localized_string_Korea_Standard_Time = N'Korea Standard Time'
declare @localized_string_Korea_Daylight_Time NVARCHAR(128)
set @localized_string_Korea_Daylight_Time = N'Korea Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (63,@localized_string_Seoul,@localized_string_Korea_Standard_Time,@localized_string_Korea_Daylight_Time,-540,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Adelaide NVARCHAR(128)
set @localized_string_Adelaide = N'(GMT+09:30) Adelaide'
declare @localized_string_Cen_Australia_Standard_Time NVARCHAR(128)
set @localized_string_Cen_Australia_Standard_Time = N'Cen. Australia Standard Time'
declare @localized_string_Cen_Australia_Daylight_Time NVARCHAR(128)
set @localized_string_Cen_Australia_Daylight_Time = N'Cen. Australia Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (64,@localized_string_Adelaide,@localized_string_Cen_Australia_Standard_Time,@localized_string_Cen_Australia_Daylight_Time,-570,0,-60,0,3,0,5,2,0,0,0,0,10,0,5,2,0,0,0)
declare @localized_string_Darwin NVARCHAR(128)
set @localized_string_Darwin = N'(GMT+09:30) Darwin'
declare @localized_string_AUS_Central_Standard_Time NVARCHAR(128)
set @localized_string_AUS_Central_Standard_Time = N'AUS Central Standard Time'
declare @localized_string_AUS_Central_Daylight_Time NVARCHAR(128)
set @localized_string_AUS_Central_Daylight_Time = N'AUS Central Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (65,@localized_string_Darwin,@localized_string_AUS_Central_Standard_Time,@localized_string_AUS_Central_Daylight_Time,-570,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Guam_Port_Moresby NVARCHAR(128)
set @localized_string_Guam_Port_Moresby = N'(GMT+10:00) Guam, Port Moresby'
declare @localized_string_West_Pacific_Standard_Time NVARCHAR(128)
set @localized_string_West_Pacific_Standard_Time = N'West Pacific Standard Time'
declare @localized_string_West_Pacific_Daylight_Time NVARCHAR(128)
set @localized_string_West_Pacific_Daylight_Time = N'West Pacific Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (66,@localized_string_Guam_Port_Moresby,@localized_string_West_Pacific_Standard_Time,@localized_string_West_Pacific_Daylight_Time,-600,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Vladivostok NVARCHAR(128)
set @localized_string_Vladivostok = N'(GMT+10:00) Vladivostok'
declare @localized_string_Vladivostok_Standard_Time NVARCHAR(128)
set @localized_string_Vladivostok_Standard_Time = N'Vladivostok Standard Time'
declare @localized_string_Vladivostok_Daylight_Time NVARCHAR(128)
set @localized_string_Vladivostok_Daylight_Time = N'Vladivostok Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (67,@localized_string_Vladivostok,@localized_string_Vladivostok_Standard_Time,@localized_string_Vladivostok_Daylight_Time,-600,0,-60,0,10,0,5,3,0,0,0,0,3,0,5,2,0,0,0)
declare @localized_string_Hobart NVARCHAR(128)
set @localized_string_Hobart = N'(GMT+10:00) Hobart'
declare @localized_string_Tasmania_Standard_Time NVARCHAR(128)
set @localized_string_Tasmania_Standard_Time = N'Tasmania Standard Time'
declare @localized_string_Tasmania_Daylight_Time NVARCHAR(128)
set @localized_string_Tasmania_Daylight_Time = N'Tasmania Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (68,@localized_string_Hobart,@localized_string_Tasmania_Standard_Time,@localized_string_Tasmania_Daylight_Time,-600,0,-60,0,3,0,5,2,0,0,0,0,10,0,1,2,0,0,0)
declare @localized_string_Brisbane NVARCHAR(128)
set @localized_string_Brisbane = N'(GMT+10:00) Brisbane'
declare @localized_string_Australia_Standard_Time NVARCHAR(128)
set @localized_string_Australia_Standard_Time = N'E. Australia Standard Time'
declare @localized_string_Australia_Daylight_Time NVARCHAR(128)
set @localized_string_Australia_Daylight_Time = N'E. Australia Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (69,@localized_string_Brisbane,@localized_string_Australia_Standard_Time,@localized_string_Australia_Daylight_Time,-600,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Canberra_Melbourne_Sydney NVARCHAR(128)
set @localized_string_Canberra_Melbourne_Sydney = N'(GMT+10:00) Canberra, Melbourne, Sydney'
declare @localized_string_AUS_Eastern_Standard_Time NVARCHAR(128)
set @localized_string_AUS_Eastern_Standard_Time = N'AUS Eastern Standard Time'
declare @localized_string_AUS_Eastern_Daylight_Time NVARCHAR(128)
set @localized_string_AUS_Eastern_Daylight_Time = N'AUS Eastern Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (70,@localized_string_Canberra_Melbourne_Sydney,@localized_string_AUS_Eastern_Standard_Time,@localized_string_AUS_Eastern_Daylight_Time,-600,0,-60,0,3,0,5,2,0,0,0,0,10,0,5,2,0,0,0)
declare @localized_string_Magadan_Solomon_New_Caledonia NVARCHAR(128)
set @localized_string_Magadan_Solomon_New_Caledonia = N'(GMT+11:00) Magadan, Solomon Is., New Caledonia'
declare @localized_string_Central_Pacific_Standard_Time NVARCHAR(128)
set @localized_string_Central_Pacific_Standard_Time = N'Central Pacific Standard Time'
declare @localized_string_Central_Pacific_Daylight_Time NVARCHAR(128)
set @localized_string_Central_Pacific_Daylight_Time = N'Central Pacific Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (71,@localized_string_Magadan_Solomon_New_Caledonia,@localized_string_Central_Pacific_Standard_Time,@localized_string_Central_Pacific_Daylight_Time,-660,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Auckland_Wellington NVARCHAR(128)
set @localized_string_Auckland_Wellington = N'(GMT+12:00) Auckland, Wellington'
declare @localized_string_New_Zealand_Standard_Time NVARCHAR(128)
set @localized_string_New_Zealand_Standard_Time = N'New Zealand Standard Time'
declare @localized_string_New_Zealand_Daylight_Time NVARCHAR(128)
set @localized_string_New_Zealand_Daylight_Time = N'New Zealand Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (72,@localized_string_Auckland_Wellington,@localized_string_New_Zealand_Standard_Time,@localized_string_New_Zealand_Daylight_Time,-720,0,-60,0,3,0,3,2,0,0,0,0,10,0,1,2,0,0,0)
declare @localized_string_Fiji_Kamchatka_Marshall NVARCHAR(128)
set @localized_string_Fiji_Kamchatka_Marshall = N'(GMT+12:00) Fiji, Kamchatka, Marshall Is.'
declare @localized_string_Fiji_Standard_Time NVARCHAR(128)
set @localized_string_Fiji_Standard_Time = N'Fiji Standard Time'
declare @localized_string_Fiji_Daylight_Time NVARCHAR(128)
set @localized_string_Fiji_Daylight_Time = N'Fiji Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (73,@localized_string_Fiji_Kamchatka_Marshall,@localized_string_Fiji_Standard_Time,@localized_string_Fiji_Daylight_Time,-720,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
declare @localized_string_Nuku_alofa NVARCHAR(128)
set @localized_string_Nuku_alofa = N'(GMT+13:00) Nuku''alofa'
declare @localized_string_Tonga_Standard_Time NVARCHAR(128)
set @localized_string_Tonga_Standard_Time = N'Tonga Standard Time'
declare @localized_string_Tonga_Daylight_Time NVARCHAR(128)
set @localized_string_Tonga_Daylight_Time = N'Tonga Daylight Time'
INSERT INTO TblReferenceTimeZone (TzID,DisplayName,StdName,DltName,Bias,StdBias,DltBias,StdYear,StdMonth,StdDayWeek,StdDay,StdHour,StdMin,StdSec,StdMs,DltYear,DltMonth,DltDayWeek,DltDay,DltHour,DltMin,DltSec,DltMs) VALUES (74,@localized_string_Nuku_alofa,@localized_string_Tonga_Standard_Time,@localized_string_Tonga_Daylight_Time,-780,0,-60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
REFERENCES For more information about support for DST changes in
Microsoft Windows operating systems, visit the following Microsoft Web site:
APPLIES TO | Microsoft Commerce Server 2007 Enterprise Edition | | Microsoft Commerce Server 2007 Developer Edition | | Microsoft Commerce Server 2007 Standard Edition | | Microsoft Commerce Server 2002 Standard Edition |
| kbmsccsearch kbpubtypekc kbinfo kbhowto KB932395 |
|
 |
 |
 |
 |
|