ApsaraDB RDS for MySQL and ApsaraDB RDS for PostgreSQL support named time zones based on the IANA tz database. Use this page to look up:
Time zone abbreviations accepted by RDS for MySQL instances and their corresponding IANA names
Named time zones available for both RDS for MySQL and RDS for PostgreSQL instances
Default time zones assigned to RDS for PostgreSQL instances by region
Time zone abbreviations for RDS for MySQL instances
The following table maps supported time zone abbreviations to their IANA time zone names. Use these values when setting the time_zone parameter to an abbreviation.
Some abbreviations are ambiguous across regions. In ApsaraDB RDS for MySQL,CSTmaps to UTC+08:00 (China Standard Time), not UTC-06:00 (North American Central Standard Time). In multi-region environments, use the full IANA name (for example,Asia/Shanghai) instead of an abbreviation to avoid misconfiguration.
| Time zone abbreviation | Time zone |
|---|---|
| AEST | Australia/Sydney |
| AEDT | Australia/Sydney |
| BST | Europe/London |
| CEST | Europe/Berlin |
| CET | Europe/Berlin |
| CST | +08:00 |
| EDT | America/New_York |
| EST | Australia/Sydney |
| GST | Asia/Dubai |
| JST | Asia/Tokyo |
| PDT | America/Los_Angeles |
| PST | America/Los_Angeles |
| WIB | Asia/Jakarta |
Common time zones for RDS for MySQL and RDS for PostgreSQL instances
The following named time zones are available for both RDS for MySQL and RDS for PostgreSQL instances. Set the time_zone parameter to any of these IANA time zone names.
| 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/Tijiana |
| 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 |
Default time zones for RDS for PostgreSQL instances by region
RDS for PostgreSQL assigns a default time zone to each instance based on its region. The following table lists the default time zone for each supported region.
| Region | Region ID | Default time zone |
|---|---|---|
| China (Hangzhou) | cn-hangzhou | Asia/Shanghai |
| China (Shanghai) | cn-shanghai | Asia/Shanghai |
| China (Nanjing - Local Region) | 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 |