|
Parameterization of Time Zones for Data Connectors
Aside from selecting a Windows time zone name in the Timezone field of the following data connectors, you can now parameterize the time zone per connection:
Selecting a Windows time zone
Entering a parameterized time zone
In the Parameters section of the Edit Data Table window, the following dynamic parameterization formats are supported:
-
Windows Timezone ID
-
IANA
-
Custom: GMT +/- hours:minutes
For example:
Refer to the table below for the list of Windows time zone and IANA names that you can use:
| Windows Name |
IANA Name |
| Alaskan Standard Time |
"America/Anchorage" |
| Arabian Standard Time |
"Asia/Dubai" |
| Atlantic Standard Time |
"America/Halifax" |
| Caucasus Standard Time |
"Asia/Yerevan" |
| Cen. Australia Standard Time |
"Australia/Adelaide" |
| Central America Standard Time |
"America/Guatemala" |
| Central Asia Standard Time |
"Asia/Almaty" |
| Central Europe Standard Time |
"Europe/Budapest" |
| Central European Standard Time |
"Europe/Warsaw" |
| Central Pacific Standard Time |
"Pacific/Guadalcanal" |
| Central Standard Time |
"America/Chicago" |
| China Standard Time |
"Asia/Shanghai" |
| Dateline Standard Time |
"Etc/GMT+12" |
| E. Africa Standard Time |
"Africa/Nairobi" |
| E. Australia Standard Time |
"Australia/Brisbane" |
| E. Europe Standard Time |
"Asia/Nicosia" |
| E. South America Standard Time |
"America/Sao_Paulo" |
| Eastern Standard Time |
"America/New_York" |
| Egypt Standard Time |
"Africa/Cairo" |
| GMT Standard Time |
"Europe/London" |
| Greenland Standard Time |
"America/Godthab" |
| Greenwich Standard Time |
"Atlantic/Reykjavik" |
| Hawaiian Standard Time |
"Pacific/Honolulu" |
| India Standard Time |
"Asia/Calcutta" |
| Iran Standard Time |
"Asia/Tehran" |
| Israel Standard Time |
Asia/Jerusalem" |
| Korea Standard Time |
"Asia/Seoul" |
| Mountain Standard Time |
"America/Denver" |
| N. Central Asia Standard Time |
"Asia/Novosibirsk" |
| New Zealand Standard Time |
"Pacific/Auckland" |
| Newfoundland Standard Time |
"America/St_Johns" |
| North Asia East Standard Time |
"Asia/Irkutsk" |
| North Asia Standard Time |
"Asia/Krasnoyarsk" |
| Pacific SA Standard Time |
"America/Santiago" |
| Pacific Standard Time |
"America/Los_Angeles" |
| Russian Standard Time |
"Europe/Moscow" |
| SA Eastern Standard Time |
"America/Cayenne" |
| SA Pacific Standard Time |
"America/Bogota" |
| SA Western Standard Time |
"America/La_Paz" |
| Samoa Standard Time |
"Pacific/Apia" |
| SE Asia Standard Time |
"Asia/Bangkok" |
| Singapore Standard Time |
"Asia/Singapore" |
| South Africa Standard Time |
"Africa/Johannesburg" |
| Sri Lanka Standard Time |
"Asia/Colombo" |
| Taipei Standard Time |
"Asia/Taipei" |
| Tasmania Standard Time |
"Australia/Hobart" |
| Tokyo Standard Time |
"Asia/Tokyo" |
| US Eastern Standard Time |
"America/Indianapolis" |
| Vladivostok Standard Time |
"Asia/Vladivostok" |
| W. Australia Standard Time |
"Australia/Perth" |
| W. Central Africa Standard Time |
"Africa/Lagos" |
| W. Europe Standard Time |
"Europe/Berlin" |
| West Asia Standard Time |
"Asia/Tashkent" |
| West Pacific Standard Time |
"Pacific/Port_Moresby" |
| Yakutsk Standard Time |
"Asia/Yakutsk" |