Time Zone Codes

SQL Server 2005 Notification Services supports the time zone codes listed in the following table. If your application supports scheduled subscriptions for multiple time zones, use these codes to identify the subscription time zone. Notification Services converts the local time entered by the user to Coordinated Universal Time (UTC) using the UTC offset value. This ensures that Notification Services generates notifications for the scheduled subscription at the appropriate time for the user's location.

Time zone codes are stored in the NSTimeZones table in the instance database for each Notification Services instance. Additionally, related time zone information, such as location and standard names, is in the NSTimeZoneNames table.

The UTC offset value is the number of SqlDateTime data-type clock "ticks" between UTC and the time zone. To obtain the number of hours between UTC and the time zone, divide the UTC offset value by 1080000.

Time zone ID Time zone name UTC offset

0

Dateline Time

-12960000

1

Samoa Time

-11880000

2

Hawaiian Time

-10800000

3

Alaskan Time

-9720000

4

Pacific Time

-8640000

10

Mountain Time

-7560000

13

Mexico2 Time

-7560000

15

US Mountain Time

-7560000

20

Central Time

-6480000

25

Canada Central Time

-6480000

30

Mexico Time

-6480000

33

Central America Time

-6480000

35

Eastern Time

-5400000

40

US Eastern Time

-5400000

45

SA Pacific Time

-5400000

50

Atlantic Time

-4320000

55

SA Western Time

-4320000

56

Pacific SA Time

-4320000

60

Newfoundland Time

-3780000

65

E. South America Time

-3240000

70

SA Eastern Time

-3240000

73

Greenland Time

-3240000

75

Mid-Atlantic Time

-2160000

80

Azores Time

-1080000

83

Cape Verde Time

-1080000

85

GMT Time

0

90

Greenwich Time

0

95

Central Europe Time

1080000

100

Central European Time

1080000

105

Romance Time

1080000

110

W. Europe Time

1080000

113

W. Central Africa Time

1080000

115

E. Europe Time

2160000

120

Egypt Time

2160000

125

FLE Time

2160000

130

GTB Time

2160000

135

Jerusalem Time

2160000

140

South Africa Time

2160000

145

Russian Time

3240000

150

Arab Time

3240000

155

E. Africa Time

3240000

158

Arabic Time

3240000

160

Iran Time

3780000

165

Arabian Time

4320000

170

Caucasus Time

4320000

175

Afghanistan Time

4860000

180

Ekaterinburg Time

5400000

185

West Asia Time

5400000

190

India Time

5940000

193

Nepal Time

6210000

195

Central Asia Time

6480000

200

Sri Lanka Time

6480000

201

N. Central Asia Time

6480000

203

Myanmar Time

7020000

205

SE Asia Time

7560000

207

North Asia Time

7560000

210

China Time

8640000

215

Malay Peninsula Time

8640000

220

Taipei Time

8640000

225

W. Australia Time

8640000

227

North Asia East Time

8640000

230

Korea Time

9720000

235

Tokyo Time

9720000

240

Yakutsk Time

9720000

245

AUS Central Time

10260000

250

Cen. Australia Time

10260000

255

AUS Eastern Time

10800000

260

E. Australia Time

10800000

265

Tasmania Time

10800000

270

Vladivostok Time

10800000

275

West Pacific Time

10800000

280

Central Pacific Time

11880000

285

Fiji Islands Time

12960000

290

New Zealand Time

12960000

300

Tonga Time

14040000

360

Coordinated Universal Time (UTC)

0

See Also

Other Resources

Adding a Subscription
Populating a Time Zone List
Notification Services Programming Reference

Help and Information

Getting SQL Server 2005 Assistance