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