Export (0) Print
Expand All

Time Zone Codes

SQL Server 2000

The time zone codes in the following table ship with Notification Services.

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
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

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft