I would like to change the time zone of my Amazon RDS database instance to the local time zone.

All Amazon RDS DB instances use UTC/GMT time by default.

The steps required to modify the time zone of an Amazon RDS DB instance vary depending on the database engine.

Oracle – The steps required to modify the time zone for RDS Oracle DB instances are documented at Setting the Database Time Zone and require Oracle Database Engine version 11.2.0.2.v4.

PostgreSQL – Modification of the time zone for RDS PostgreSQL DB instances is performed at the database level by setting the value of the timezone parameter in a custom parameter group. The timezone parameter takes the input form of UTC-X or UTC+X where X is the number of hours that the time zone should be offset from UTC time.

MySQL – By default, the time zone for RDS MySQL DB instances is Coordinated Universal Time (UTC). If you are using MySQL 5.5, 5.6, or 5.7, you can change the time zone for an instance by setting the time_zone parameter in the parameter group for the instance. All instances and read replicas that use the parameter group will change to use the new time zone. You cannot change the time zone for RDS MySQL versions prior to 5.5. For more information, see Local Time Zone for MySQL DB Instances.

Amazon Aurora
You can change the time zone for the Aurora DB cluster as described at Local Time Zone for Amazon Aurora DB Clusters.

MariaDB – By default, the time zone for RDS MariaDB DB instances is Coordinated Universal Time (UTC). You can change the time zone for an instance by setting the time_zone parameter in the parameter group for the instance. All instances and read replicas that use the parameter group will change to use the new time zone. For more information, see Local Time Zone for MariaDB DB Instances.

SQL Server – Amazon for RDS SQL Server supports Local Time Zones. To change the time zone while creating a new RDS for SQL Server instance, use the ‘Select your Time Zone’ dropdown in the AWS Management Console. The time zone cannot be modified once the instance has been created. For more information, see Local Time Zone for Microsoft SQL Server DB Instances.

Amazon RDS, change time zone, UTC, parameter group, timezone table data, default timezone


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-10-30
Updated: 2016-06-01