This topic lists mappings between time zone abbreviations and named time zones for RDS for MySQL, common named time zones for RDS for MySQL and RDS for PostgreSQL instances, and mappings between regions and default named time zones for RDS for PostgreSQL instances.
Mappings between time zone abbreviations and named time zones for RDS for MySQL
Time zone abbreviation | Time zone name |
CEST | Europe/Berlin |
CST | +08:00 |
CET | Europe/Berlin |
GST | Asia/Dubai |
JST | Asia/Tokyo |
EST | Australia/Sydney |
BST | Europe/London |
WIB | Asia/Jakarta |
AEST | Australia/Sydney |
AEDT | Australia/Sydney |
PDT | America/Los_Angeles |
PST | America/Los_Angeles |
EDT | America/New_York |
Common named time zones for RDS for MySQL and RDS for PostgreSQL instances
Area | Named time zone |
Africa | Africa/Cairo, Africa/Casablanca, Africa/Harare, Africa/Monrovia, Africa/Nairobi, Africa/Tripoli, and Africa/Windhoek |
America | America/Araguaina, America/Asuncion, America/Bogota, America/Caracas, America/Chihuahua, America/Cuiaba, America/Denver, America/Fortaleza, America/Guatemala, America/Halifax, America/Manaus, America/Matamoros, America/Monterrey, America/Montevideo, America/New_York, America/Phoenix, America/Santiago, and America/Tijuana |
Asia | Asia/Amman, Asia/Ashgabat, Asia/Baghdad, Asia/Baku, Asia/Bangkok, Asia/Beirut, Asia/Calcutta, Asia/Damascus, Asia/Dhaka, Asia/Irkutsk, Asia/Jerusalem, Asia/Kabul, Asia/Karachi, Asia/Kathmandu, Asia/Krasnoyarsk, Asia/Madadan, Asia/Muscat, Asia/Novosibirsk, Asia/Riyadh, Asia/Seoul, Asia/Shanghai, Asia/Singapore, Asia/Taipei, Asia/Tehran, Asia/Tokyo, Asia/Ulaanbaatar, Asia/Vladivostok, Asia/Yakutsk, and Asia/Yerevan |
Atlantic | Atlantic/Azores |
Australia | Australia/Adelaide, Australia/Brisbane, Australia/Darwin, Australia/Hobart, Australia/Perth, and Australia/Sydney |
Brazil | Brazil/East |
Canada | Canada/Newfoundland and Canada/Saskatchewan |
Europe | Europe/Amsterdam, Europe/Athens, Europe/Dublin, Europe/Helsinki, Europe/Istanbul, Europe/Kaliningrad, Europe/Moscow, Europe/Paris, Europe/Prague, and Europe/Sarajevo |
Pacific | Pacific/Auckland, Pacific/Fiji, Pacific/Guam, Pacific/Honolulu, and Pacific/Samoa |
US | US/Alaska, US/Central, US/East-Indiana, US/Eastern, and US/Pacific |
Mappings between regions and default named time zones for RDS for PostgreSQL instances
Region | Region ID | Named time zone |
China (Hangzhou) | cn-hangzhou | Asia/Shanghai |
China (Shanghai) | cn-shanghai | Asia/Shanghai |
China (Nanjing - Local Region - Decommissioning) | cn-nanjing | Asia/Shanghai |
China (Qingdao) | cn-qingdao | Asia/Shanghai |
China (Beijing) | cn-beijing | Asia/Shanghai |
China (Zhangjiakou) | cn-zhangjiakou | Asia/Shanghai |
China (Hohhot) | cn-huhehaote | Asia/Shanghai |
China (Ulanqab) | cn-wulanchabu | Asia/Shanghai |
China (Shenzhen) | cn-shenzhen | Asia/Shanghai |
China (Heyuan) | cn-heyuan | Asia/Shanghai |
China (Guangzhou) | cn-guangzhou | Asia/Shanghai |
China (Chengdu) | cn-chengdu | Asia/Shanghai |
China (Hong Kong) | cn-hongkong | Asia/Hong_Kong |
Singapore | ap-southeast-1 | Asia/Singapore |
Malaysia (Kuala Lumpur) | ap-southeast-3 | Asia/Kuala_Lumpur |
Indonesia (Jakarta) | ap-southeast-5 | Asia/Jakarta |
Japan (Tokyo) | ap-northeast-1 | Asia/Tokyo |
Germany (Frankfurt) | eu-central-1 | Europe/Berlin |
UK (London) | eu-west-1 | Europe/London |
US (Silicon Valley) | us-west-1 | America/Los_Angeles |
US (Virginia) | us-east-1 | America/New_York |
UAE (Dubai) | me-east-1 | Asia/Dubai |