Time zones in import and export
If you want to import records containing time zones from external data sources, then you need to represent each time zone by the appropriate code. For example, in the import file, the time zone (GMT+00:00) Greenwich Mean Time: Edinburgh, London must be represented by 32.
If an entity or link type has at least one time zone field defined, then a Default Time Zone field is displayed on the final page of the import wizard. If the import file does not contain time zone values, then whatever value you select for the default will be used.
When exporting data that contains time zones, the time zone will also be represented by an iBase code.
You can include a value for the field in the imported data or provide a default time.
The time zones and their codes are listed in the following tables.
List of time zones by iBase code
The time zones in the following table are sorted in numerical order by their iBase code.
Code | Time difference | Name |
|---|---|---|
1 | (GMT+00:00) | Coordinated Universal Time |
2 | (GMT+04:30) | Kabul |
3 | (GMT-09:00) | Alaska |
4 | (GMT+03:00) | Kuwait, Riyadh |
5 | (GMT+04:00) | Abu Dhabi, Muscat |
6 | (GMT+03:00) | Baghdad |
7 | (GMT-04:00) | Atlantic Time (Canada) |
8 | (GMT+09:30) | Darwin |
9 | (GMT+10:00) | Canberra, Melbourne, Sydney |
10 | (GMT-01:00) | Azores |
11 | (GMT-06:00) | Saskatchewan |
12 | (GMT-01:00) | Cape Verde Is. |
13 | (GMT+04:00) | Baku, Yerevan |
14 | (GMT+09:30) | Adelaide |
15 | (GMT-06:00) | Central America |
16 | (GMT+06:00) | Astana, Dhaka |
17 | (GMT+01:00) | Belgrade, Bratislava, Budapest, Ljubljana, Prague |
18 | (GMT+01:00) | Sarajevo, Skopje, Sofija, Warsaw, Zagreb |
19 | (GMT+11:00) | Magadan, Solomon Is., New Caledonia |
20 | (GMT-06:00) | Central Time ( N America) |
21 | (GMT+08:00) | Beijing, Chongqing, Urumqi |
22 | (GMT-12:00) | Eniwetok, Kwajalein |
23 | (GMT+03:00) | Nairobi |
24 | (GMT+10:00) | Brisbane |
26 | (GMT-03:00) | Brasilia |
27 | (GMT-05:00) | Eastern Time ( N America) |
28 | (GMT+02:00) | Cairo |
29 | (GMT+05:00) | Ekaterinburg |
30 | (GMT+12:00) | Fiji, Kamchatka, Marshall Is. |
31 | (GMT+02:00) | Helsinki, Riga, Tallinn, Vilnius |
32 | (GMT+00:00) | Greenwich Mean Time: Edinburgh, London |
33 | (GMT-03:00) | Greenland |
34 | (GMT+00:00) | Casablanca, Monrovia |
35 | (GMT+02:00) | Athens, Istanbul, Bucharest, Minsk |
36 | (GMT-10:00) | Hawaii |
37 | (GMT+05:30) | Calcutta, Chennai, Mumbai, New Delhi |
38 | (GMT+03:30) | Tehran |
39 | (GMT+02:00) | Jerusalem |
40 | (GMT+09:00) | Seoul |
41 | (GMT-06:00) | Guadalajara, Mexico City, Monterrey |
42 | (GMT-02:00) | Mid-Atlantic |
43 | (GMT-07:00) | Mountain Time ( N America) |
44 | (GMT+06:30) | Yangon, Rangoon |
45 | (GMT+06:00) | Novosibirsk |
46 | (GMT+05:45) | Kathmandu |
47 | (GMT+12:00) | Auckland, Wellington |
48 | (GMT-03:30) | Newfoundland |
49 | (GMT+08:00) | Irkutsk, Ulaan Bataar |
50 | (GMT+07:00) | Krasnoyarsk |
51 | (GMT-04:00) | Santiago |
52 | (GMT-08:00) | Pacific Time ( N America) |
53 | (GMT+01:00) | Brussels, Copenhagen, Madrid, Paris |
54 | (GMT+03:00) | Moscow, St. Petersburg, Volgograd |
55 | (GMT-03:00) | Buenos Aires |
56 | (GMT-05:00) | Bogota, Lima, Quito |
57 | (GMT-04:00) | Caracas, La Paz |
58 | (GMT-11:00) | Midway Island, Samoa |
59 | (GMT+07:00) | Bangkok, Hanoi, Jakarta |
60 | (GMT+08:00) | Kuala Lumpur, Singapore |
61 | (GMT+02:00) | Harare, Pretoria |
62 | (GMT+06:00) | Sri Jayawardenepura |
63 | (GMT+08:00) | Taipei |
64 | (GMT+10:00) | Hobart |
65 | (GMT+09:00) | Osaka, Sapporo, Tokyo |
66 | (GMT+13:00) | Nuku'alofa |
67 | (GMT-05:00) | Indiana (East) |
68 | (GMT-07:00) | Arizona |
69 | (GMT+10:00) | Vladivostok |
70 | (GMT+08:00) | Perth |
71 | (GMT+01:00) | West Central Africa |
72 | (GMT+01:00) | Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna |
73 | (GMT+05:00) | Islamabad, Karachi |
74 | (GMT+10:00) | Guam, Port Moresby |
75 | (GMT+09:00) | Yakutsk |
76 | (GMT-12:00) | Yankee (military) |
77 | (GMT-11:00) | X-ray (military) |
78 | (GMT-10:00) | Whiskey (military) |
79 | (GMT-09:00) | Victor (military) |
80 | (GMT-08:00) | Uniform (military) |
81 | (GMT-07:00) | Tango (military) |
82 | (GMT-06:00) | Sierra (military) |
83 | (GMT-05:00) | Romeo (military) |
84 | (GMT-04:00) | Quebec (military) |
85 | (GMT-03:00) | Papa (military) |
86 | (GMT-02:00) | Oscar (military) |
87 | (GMT-01:00) | November (military) |
88 | (GMT+00:00) | Zulu (military) |
89 | (GMT+01:00) | Alpha (military) |
90 | (GMT+02:00) | Bravo (military) |
91 | (GMT+03:00) | Charlie (military) |
92 | (GMT+04:00) | Delta (military) |
93 | (GMT+05:00) | Echo (military) |
94 | (GMT+06:00) | Foxtrot (military) |
95 | (GMT+07:00) | Golf (military) |
96 | (GMT+08:00) | Hotel (military) |
97 | (GMT+09:00) | India (military) |
98 | (GMT+10:00) | Kilo (military) |
99 | (GMT+11:00) | Lima (military) |
100 | (GMT+12:00) | Mike (military) |
101 | (GMT+02:00) | Amman |
102 | (GMT+00:00) | Dublin |
103 | (GMT+00:00) | Lisbon |
104 | (GMT-06:00) | Galapagos |
105 | (GMT-06:00) | Easter Island (Chile) |
106 | (GMT-05:00) | Cuba |
107 | (GMT-04:00) | Falkland Islands |
108 | (GMT-04:00) | Paraguay |
110 | (GMT-03:00) | Eastern Brazil |
111 | (GMT-03:00) | Uruguay |
112 | (GMT-03:00) | French Guiana |
113 | (GMT-02:00) | Fernando de Noronha (Brazil) |
114 | (GMT+05:00) | Tashkent |
115 | (GMT+01:00) | Windhoek |
116 | (GMT-01:00) | Tunis |
117 | (GMT-04:00) | Tbilisi |
118 | (GMT-02:00) | Beirut |
119 | (GMT-06:00) | Almaty |
120 | (GMT+07:00) | Chihuahua, La Paz, Mazatlan |
121 | (GMT-08:00) | Tijuana, Baja California |
122 | (GMT+04:00) | Manaus |