Satya shows you how to
change the time zone
for an RDS instance running MySQL

satya-rds-change-time-zone

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

All RDS DB instances use UTC/GMT time by default, and changing your time zone is optional. We strongly recommend using UTC time zone at the database layer, but if you must use a local time zone, always convert the time zone at the application layer. Before changing your time zone, consult your database administrator or application team.

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 time zone parameter in a custom parameter group. The time zone 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.

Important: PostgreSQL processes time zones differently if they are referenced as UTC-5 vs "America/New_York". For example, the time zone "America/New_York" will display UTC-5. If you set the time zone as UTC-5, it will update as UTC+5. For more information, see PostgreSQL Date/Time Types.

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 can't 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 can't be modified after the instance is created. For more information, see Local Time Zone for Microsoft SQL Server DB Instances.


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: 2018-05-25