Time zones
ApsaraDB RDS for MySQL and ApsaraDB RDS for PostgreSQL support time zones from the Internet Assigned Numbers Authority (IANA) time zone database. This page lists the supported time zone abbreviations for RDS for MySQL, the full set of named time zones for both engines, and the default time zone for each RDS for PostgreSQL region.
RDS uses two formats to identify time zones:
Time zone abbreviations (for example,
CST,JST) represent a fixed UTC offset and do not account for daylight saving time. Use these in date/time input values or with theAT TIME ZONEoperator in SQL. You cannot use abbreviations as the value of an instance time zone parameter.Named time zones (for example,
Asia/Shanghai,America/New_York) are IANA identifiers that encode daylight saving time rules. Use these when setting the instance time zone parameter.
Time zone abbreviation mappings for RDS for MySQL instances
Time zone abbreviation | Named time zone | UTC offset |
AEST | Australia/Sydney | +10:00 |
AEDT | Australia/Sydney | +11:00 |
BST | Europe/London | +01:00 |
CEST | Europe/Berlin | +02:00 |
CET | Europe/Berlin | +01:00 |
CST | +08:00 | +08:00 |
EDT | America/New_York | -04:00 |
EST | Australia/Sydney | +10:00 |
GST | Asia/Dubai | +04:00 |
JST | Asia/Tokyo | +09:00 |
PDT | America/Los_Angeles | -07:00 |
PST | America/Los_Angeles | -08:00 |
WIB | Asia/Jakarta | +07:00 |
Supported named time zones for RDS for MySQL and RDS for PostgreSQL instances
Area | Named time zones |
Africa | Africa/Cairo, Africa/Casablanca, Africa/Harare, Africa/Monrovia, Africa/Nairobi, Africa/Tripoli, 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, 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, Asia/Yerevan |
Atlantic | Atlantic/Azores |
Australia | Australia/Adelaide, Australia/Brisbane, Australia/Darwin, Australia/Hobart, Australia/Perth, Australia/Sydney |
Brazil | Brazil/East |
Canada | Canada/Newfoundland, Canada/Saskatchewan |
Europe | Europe/Amsterdam, Europe/Athens, Europe/Dublin, Europe/Helsinki, Europe/Istanbul, Europe/Kaliningrad, Europe/Moscow, Europe/Paris, Europe/Prague, Europe/Sarajevo |
Pacific | Pacific/Auckland, Pacific/Fiji, Pacific/Guam, Pacific/Honolulu, Pacific/Samoa |
US | US/Alaska, US/Central, US/East-Indiana, US/Eastern, US/Pacific |
Default time zones for RDS for PostgreSQL instances by region
The default time zone of an RDS for PostgreSQL instance is determined by its 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 |