ApsaraDB RDS for MySQL and ApsaraDB RDS for PostgreSQL each handle time zones differently. Use the tables below to find the correct named time zone value for your instance configuration.
RDS for MySQL: Use the abbreviation-to-name mapping to translate a common abbreviation (such as CST or JST) into a named time zone value accepted by the
time_zoneparameter. The common named time zones table lists all supported values for that parameter.RDS for PostgreSQL: Use the region-to-default table to identify the default named time zone assigned when an instance is created in a given region.
Time zone abbreviation mappings for RDS for MySQL
RDS for MySQL accepts named time zone values—not abbreviations—as the time_zone parameter value. Use this table to find the named time zone that corresponds to a common abbreviation.
| Abbreviation | Named time zone |
|---|---|
| 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 |
Supported named time zones for RDS for MySQL and RDS for PostgreSQL
The following named time zones are supported for both RDS for MySQL and RDS for PostgreSQL instances. Named time zones follow the IANA time zone database format.
| Area | Named time zones |
|---|---|
| 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 |
Default time zones by region for RDS for PostgreSQL
When you create an RDS for PostgreSQL instance, it is assigned the default named time zone for its region. The table below lists the default time zone for each available region.
| Region | Region ID | Default 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 |