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