Was this helpful?
Time Zone Name Mappings
Ingres time zone names map to IANA time zone names as follows:
AUSTRALIA-LHI=Australia-Lord_Howe
AUSTRALIA-NORTH=Australia-Darwin
AUSTRALIA-NSW=Australia-Sydney
AUSTRALIA-QUEENSLAND=Australia-Brisbane
AUSTRALIA-SOUTH=Australia-Adelaide
AUSTRALIA-TASMANIA=Australia-Hobart
AUSTRALIA-VICTORIA=Australia-Melbourne
AUSTRALIA-WEST=Australia-Perth
AUSTRALIA-YANCO=Australia-Adelaide
BRAZIL-ACRE=America-Rio_Branco
BRAZIL-DENORONHA=America-Noronha
BRAZIL-EAST=America-Sao_Paulo
BRAZIL-WEST=America-Manaus
CANADA-ATLANTIC=America-Goose_Bay
CANADA-NEWFOUNDLAND=America-St_Johns
CANADA-YUKON=America-Dawson
CET=CET
CHILE-CONTINENTAL=America-Santiago
CHILE-EASTER-ISLAND=Pacific-Easter
EET=EET
EGYPT=Africa-Cairo
Etc-GMT-10=Etc-GMT-10
Etc-GMT-10=Etc-GMT-10
Etc-GMT+10=Etc-GMT+10
Etc-GMT+10=Etc-GMT+10
Etc-GMT-10half=Etc-GMT-10half
Etc-GMT-10half=Etc-GMT-10half
Etc-GMT-11=Etc-GMT-11
Etc-GMT-11=Etc-GMT-11
Etc-GMT+11=Etc-GMT+11
Etc-GMT+11=Etc-GMT+11
Etc-GMT-12=Etc-GMT-12
Etc-GMT-12=Etc-GMT-12
Etc-GMT+12=Etc-GMT+12
Etc-GMT+12=Etc-GMT+12
Etc-GMT-13=Etc-GMT-13
Etc-GMT-13=Etc-GMT-13
Etc-GMT-1=Etc-GMT-1
Etc-GMT-1=Etc-GMT-1
Etc-GMT+1=Etc-GMT+1
Etc-GMT+1=Etc-GMT+1
Etc-GMT-2=Etc-GMT-2
Etc-GMT-2=Etc-GMT-2
Etc-GMT+2=Etc-GMT+2
Etc-GMT+2=Etc-GMT+2
Etc-GMT+2half=Etc-GMT+2half
Etc-GMT+2half=Etc-GMT+2half
Etc-GMT-3=Etc-GMT-3
Etc-GMT-3=Etc-GMT-3
Etc-GMT+3=Etc-GMT+3
Etc-GMT+3=Etc-GMT+3
Etc-GMT-3half=Etc-GMT-3half
Etc-GMT-3half=Etc-GMT-3half
Etc-GMT+3half=Etc-GMT+3half
Etc-GMT+3half=Etc-GMT+3half
Etc-GMT-4=Etc-GMT-4
Etc-GMT-4=Etc-GMT-4
Etc-GMT+4=Etc-GMT+4
Etc-GMT+4=Etc-GMT+4
Etc-GMT-5=Etc-GMT-5
Etc-GMT-5=Etc-GMT-5
Etc-GMT+5=Etc-GMT+5
Etc-GMT+5=Etc-GMT+5
Etc-GMT-5half=Etc-GMT-5half
Etc-GMT-5half=Etc-GMT-5half
Etc-GMT-6=Etc-GMT-6
Etc-GMT-6=Etc-GMT-6
Etc-GMT+6=Etc-GMT+6
Etc-GMT+6=Etc-GMT+6
Etc-GMT-7=Etc-GMT-7
Etc-GMT-7=Etc-GMT-7
Etc-GMT+7=Etc-GMT+7
Etc-GMT+7=Etc-GMT+7
Etc-GMT-8=Etc-GMT-8
Etc-GMT-8=Etc-GMT-8
Etc-GMT+8=Etc-GMT+8
Etc-GMT+8=Etc-GMT+8
Etc-GMT-9=Etc-GMT-9
Etc-GMT-9=Etc-GMT-9
Etc-GMT+9=Etc-GMT+9
Etc-GMT+9=Etc-GMT+9
Etc-GMT-9half=Etc-GMT-9half
Etc-GMT-9half=Etc-GMT-9half
Etc-GMT=Etc-GMT
Etc-GMT=Etc-GMT
EUROPE-CENTRAL=CET
EUROPE-EASTERN=EET
EUROPE-WESTERN=WET
FIJI=Pacific-Fiji
FRANCE=Europe-Paris
GMT10-AND-HALF=Etc-GMT-10half
GMT-10=Etc-GMT+10
GMT10=Etc-GMT-10
GMT-11=Etc-GMT+11
GMT11=Etc-GMT-11
GMT-120M=Etc-GMT+2
GMT120M=Etc-GMT-2
GMT-12=Etc-GMT+12
GMT12=Etc-GMT-12
GMT13=Etc-GMT-13
GMT-150M=Etc-GMT+2half
GMT-180M=Etc-GMT+3
GMT180M=Etc-GMT-3
GMT-1=Etc-GMT+1
GMT1=Etc-GMT-1
GMT-210M=Etc-GMT+3half
GMT220M=Etc-GMT-3half
GMT-240M=Etc-GMT+4
GMT240M=Etc-GMT-4
GMT-2-AND-HALF=Etc-GMT+2half
GMT-2=Etc-GMT+2
GMT2=Etc-GMT-2
GMT-300M=Etc-GMT+5
GMT300M=Etc-GMT-5
GMT330M=Etc-GMT-5half
GMT-360M=Etc-GMT+6
GMT360M=Etc-GMT-6
GMT-3-AND-HALF=Etc-GMT+3half
GMT3-AND-HALF=Etc-GMT-3half
GMT-3=Etc-GMT+3
GMT3=Etc-GMT-3
GMT-420M=Etc-GMT+7
GMT420M=Etc-GMT-7
GMT-480M=Etc-GMT+8
GMT480M=Etc-GMT-8
GMT-4=Etc-GMT+4
GMT4=Etc-GMT-4
GMT-540M=Etc-GMT+9
GMT540M=Etc-GMT-9
GMT570M=Etc-GMT-9half
GMT5-AND-HALF=Etc-GMT-5half
GMT-5=Etc-GMT+5
GMT5=Etc-GMT-5
GMT-600M=Etc-GMT+10
GMT600M=Etc-GMT-10
GMT-60M=Etc-GMT+1
GMT60M=Etc-GMT-1
GMT630M=Etc-GMT-10half
GMT-660M=Etc-GMT+11
GMT660M=Etc-GMT-11
GMT-6=Etc-GMT+6
GMT6=Etc-GMT-6
GMT-720M=Etc-GMT+12
GMT720M=Etc-GMT-12
GMT780M=Etc-GMT-13
GMT-7=Etc-GMT+7
GMT7=Etc-GMT-7
GMT-8=Etc-GMT+8
GMT8=Etc-GMT-8
GMT9-AND-HALF=Etc-GMT-9half
GMT-9=Etc-GMT+9
GMT9=Etc-GMT-9
GMT=Etc-GMT
HONG-KONG=Asia-Hong_Kong
IIGMT=Etc-GMT
INDIA=Asia-Kolkata
INDONESIA-CENTRAL=Asia-Pontianak
INDONESIA-EAST=Asia-Makassar
INDONESIA-WEST=Asia-Pontianak
IRAN=Asia-Tehran
IRELAND=Europe-London
ISRAEL=Asia-Jerusalem
JAPAN=Asia-Tokyo
KOREA=Asia-Seoul
KUWAIT=Asia-Riyadh
MALAYSIA=Asia-Kuala_Lumpur
MEXICO-BAJANORTE=America-Tijuana
MEXICO-BAJASUR=America-Mazatlan
MEXICO-GENERAL=America-Mexico_City
MOSCOW-1=Europe-Kaliningrad
MOSCOW1=Europe-Samara
MOSCOW2=Asia-Yekaterinburg
MOSCOW3=Asia-Omsk
MOSCOW4=Asia-Krasnoyarsk
MOSCOW5=Asia-Irkutsk
MOSCOW6=Asia-Yakutsk
MOSCOW7=Asia-Vladivostok
MOSCOW8=Asia-Srednekolymsk
MOSCOW9=Asia-Kamchatka
MOSCOW=Europe-Moscow
NA-CENTRAL=America-Chicago
NA-EASTERN=America-New_York
NA-MOUNTAIN=America-Denver
NA-PACIFIC=America-Los_Angeles
NEW-ZEALAND-CHATHAM=Pacific-Chatham
NEW-ZEALAND=Pacific-Auckland
PAKISTAN=Asia-Karachi
PHILIPPINES=Asia-Manila
POLAND=Europe-Warsaw
PRC=Asia-Shanghai
ROC=Asia-Taipei
SAUDI-ARABIA=Asia-Riyadh
SINGAPORE=Asia-Singapore
THAILAND=Asia-Bangkok
TURKEY=Europe-Istanbul
UNITED-KINGDOM=Europe-London
US-ALASKA=America-Anchorage
US-HAWAII=Pacific-Honolulu
VIETNAM=Asia-Ho_Chi_Minh
WET=WET
Last modified date: 01/30/2023